Running 'connectWithNull.R' [0s]
  Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...40a41,42
> <PostgreSQLConnection>
> [1] TRUE
  Running 'createTableMixedCaseTest.R' [0s]
  Comparing 'createTableMixedCaseTest.Rout' to 'createTableMixedCaseTest.Rout.save' ...86a87,94
> Test should create foo1 and Foo2 tables
> Pass - Foo1 Table does not exist.
> Pass - foo1 Table exists.
> Pass - Foo2 Table exists.
> Pass - foo2 Table does not exist.
> Pass - "Foo2" Table does not exist.
> Pass - "foo2" Table does not exist.
> [1] TRUE
  Running 'dataTypeTests.R' [1s]
  Comparing 'dataTypeTests.Rout' to 'dataTypeTests.Rout.save' ...115a116,125
> Read Numeric values
> GOOD -- all numeric types are as expected
> GOOD -- all numeric values are as expected
> Read Logical values
> GOOD -- all logical types are as expected
> GOOD -- all logical values are as expected
> Read Character values
> GOOD -- all character types are as expected
> GOOD -- all character values are as expected
> DONE
  Running 'dateTZ.R' [1s]
  Comparing 'dateTZ.Rout' to 'dateTZ.Rout.save' ...89a90,163
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> testing UTC
> 
> **** Trying with  timestamp 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> 
> 
> **** Trying with  timestamp with time zone 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing Asia/Tokyo
> 
> **** Trying with  timestamp 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> 
> 
> **** Trying with  timestamp with time zone 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing Australlia/South
> 
> **** Trying with  timestamp 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> 
> 
> **** Trying with  timestamp with time zone 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing America/New_York
> 
> **** Trying with  timestamp 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> 
> 
> **** Trying with  timestamp with time zone 
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> [1] TRUE
  Running 'datetimeTests.R' [0s]
  Comparing 'datetimeTests.Rout' to 'datetimeTests.Rout.save' ...67a68,88
> 
> 
> **** Trying with  timestamp 
>                    tt zz
> 1 2008-07-01 14:15:16  1
> 2 2000-01-02 03:04:05  2
>   name  Sclass      type len precision scale nullOK
> 1   tt POSIXct TIMESTAMP   8        -1    -1   TRUE
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "POSIXct" "POSIXt" 
> 
> 
> **** Trying with  date 
>           tt zz
> 1 2008-07-01  1
> 2 2000-01-02  2
>   name Sclass type len precision scale nullOK
> 1   tt   Date DATE   4        -1    -1   TRUE
> [1] "2008-07-01" "2000-01-02"
> [1] "Date"
> [1] TRUE
  Running 'datetimestampwrite.R' [0s]
  Comparing 'datetimestampwrite.Rout' to 'datetimestampwrite.Rout.save' ...82a83,89
> Read Date and TIMESTAMP values
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> Check that read after write gets the same data types
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> DONE
  Running 'dbColumnInfo.R' [0s]
  Comparing 'dbColumnInfo.Rout' to 'dbColumnInfo.Rout.save' ...49a50,65
> dbColumnInfo
>       name  Sclass    type len precision scale nullOK
> 1       pk integer INTEGER   4        -1    -1   TRUE
> 2       v1  double  FLOAT8   8        -1    -1  FALSE
> 3       v2  double  FLOAT8   8        -1    -1   TRUE
> 4 ?column?  double  FLOAT8   8        -1    -1     NA
>       name  Sclass    type len precision scale nullOK
> 1       pk integer INTEGER   4        -1    -1   TRUE
> 2       v1  double  FLOAT8   8        -1    -1  FALSE
> 3       v2  double  FLOAT8   8        -1    -1   TRUE
> 4 ?column?  double  FLOAT8   8        -1    -1     NA
> SELECT result
>   pk v1 v2 ?column?
> 1  3  2 NA       NA
> Removing "AA"
> [1] TRUE
  Running 'dbExistsIssue.R' [0s]
  Comparing 'dbExistsIssue.Rout' to 'dbExistsIssue.Rout.save' ...56a57,60
> Does rockdata exist? [1] TRUE
> Does public.rockdata exist? [1] FALSE
> [1] "Removing rockdata\n"
> [1] TRUE
  Running 'dbExistsq.R' [0s]
  Comparing 'dbExistsq.Rout' to 'dbExistsq.Rout.save' ...57a58,62
> Write rock'data
> Does rock'data exist? [1] TRUE
> Does "public.rock'data" exist? [1] FALSE
> Removing rock'data
> [1] TRUE
  Running 'dbExistsqc.R' [0s]
  Comparing 'dbExistsqc.Rout' to 'dbExistsqc.Rout.save' ...95a96,108
> Does rock.data exist? 
> PASS: true
> create schema testschema and change the search_path
> Does rock.data exist? 
> PASS: false as the search_path changed
> Does testschema."rock.data" exist? 
> PASS: false as the testschema specified
> Does public."rock.data" exist? 
> PASS: true despite search_path change
> write in current schema
> Does rock.data exist? 
> PASS: true
> [1] TRUE
  Running 'dbGetQueryParams.R' [0s]
  Comparing 'dbGetQueryParams.Rout' to 'dbGetQueryParams.Rout.save' ...51a52,70
>    row.names  area    peri    shape  perm
> 1          6  7979 4010.15 0.167045  17.1
> 2          7  9333 4345.75 0.189651  17.1
> 3          8  8209 4344.75 0.164127  17.1
> 4         11  9364 4480.05 0.150944 119.0
> 5         13 10651 4036.54 0.228595  82.4
> 6         17 10962 4608.66 0.204314  58.6
> 7         18 10743 4787.62 0.262727  58.6
> 8         19 11878 4864.22 0.200071  58.6
> 9         20  9867 4479.41 0.144810  58.6
> 10        22 11876 4353.14 0.291029 142.0
>   row.names area    peri    shape  perm
> 1         6 7979 4010.15 0.167045  17.1
> 2         7 9333 4345.75 0.189651  17.1
> 3         8 8209 4344.75 0.164127  17.1
> 4        11 9364 4480.05 0.150944 119.0
> 5        20 9867 4479.41 0.144810  58.6
> [1] "Removing rockdata\n"
> [1] TRUE
  Running 'dbListFields.R' [1s]
  Comparing 'dbListFields.Rout' to 'dbListFields.Rout.save' ...59a60,65
> [1] "pk" "v1" "v2"
> PASS: 3 fields returned
> [1] "pid"  "name"
> PASS: 2 fields returned
> Removing "AA"
> [1] TRUE
  Running 'dbTransactionTests.R' [0s]
  Comparing 'dbTransactionTests.Rout' to 'dbTransactionTests.Rout.save' ...95a96,109
> begin transaction in con1
> create table rockdata in con1
> PASS rockdata is visible through con1
> PASS rockdata is invisible through con2
> commit in con1
> PASS rockdata is visible through con2
> remove the table from con1
> PASS rockdata is invisible through con2
> begin transaction in con1
> create table rockdata in con1
> PASS rockdata is visible through con1
> RollBack con1
> PASS rockdata is invisible through con1
> [1] TRUE
  Running 'dbWriteTableSchema.R' [0s]
  Comparing 'dbWriteTableSchema.Rout' to 'dbWriteTableSchema.Rout.save' ...52a53,65
>    row.names area    peri     shape  perm
> 1          1 4990 2791.90 0.0903296   6.3
> 2          2 7002 3892.60 0.1486220   6.3
> 3          3 7558 3930.66 0.1833120   6.3
> 4          4 7352 3869.32 0.1170630   6.3
> 5          5 7943 3948.54 0.1224170  17.1
> 6          6 7979 4010.15 0.1670450  17.1
> 7          7 9333 4345.75 0.1896510  17.1
> 8          8 8209 4344.75 0.1641270  17.1
> 9          9 8393 3682.04 0.2036540 119.0
> 10        10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
  Running 'dbWriteTableTest.R' [0s]
  Comparing 'dbWriteTableTest.Rout' to 'dbWriteTableTest.Rout.save' ...52a53,65
>    row.names area    peri     shape  perm
> 1          1 4990 2791.90 0.0903296   6.3
> 2          2 7002 3892.60 0.1486220   6.3
> 3          3 7558 3930.66 0.1833120   6.3
> 4          4 7352 3869.32 0.1170630   6.3
> 5          5 7943 3948.54 0.1224170  17.1
> 6          6 7979 4010.15 0.1670450  17.1
> 7          7 9333 4345.75 0.1896510  17.1
> 8          8 8209 4344.75 0.1641270  17.1
> 9          9 8393 3682.04 0.2036540 119.0
> 10        10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
  Running 'dbWriteTabletypes.R' [0s]
  Comparing 'dbWriteTabletypes.Rout' to 'dbWriteTabletypes.Rout.save' ...234a235,264
>   row.names            strings
> 1         1             normal
> 2         2              t\tab
> 3         3     v\vertical tab
> 4         4          n\newline
> 5         5 r carriage \retern
> 6         6      back \\ slash
> 7         7        f\form feed
> [1] "Removing rockdata\n"
> 1 	normal
> 2 	müß
> [1] "Removing rockdata\n"
> PASS:  could write small umlaut u and ligature sz
> 1 	normal
> 2 	kanji漢字
> [1] "Removing rockdata\n"
> PASS:  could write kanji
> Read Numeric values
> PASS -- all integer is as expected
> PASS integer value is preservedGOOD -- all numeric values are as expected
> Read Logical values
> GOOD -- all logical types are as expected
> GOOD -- all logical values are as expected
> Read Character values
> GOOD -- all character types are as expected
> GOOD -- all character values are as expected
> Check that read after write gets the same data types
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> DONE
  Running 'dbtemptable.R' [0s]
  Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ...48a49,51
>   name
> 1  bar
> PASS -- ended without segmentation fault
  Running 'escape.R' [0s]
  Comparing 'escape.Rout' to 'escape.Rout.save' ...42a43,45
> [1] "aaa"
> [1] "aa''a"
> [1] TRUE
  Running 'loadDriverAndConnect.R' [0s]
  Comparing 'loadDriverAndConnect.Rout' to 'loadDriverAndConnect.Rout.save' ...39a40,43
>     datname encoding datallowconn
> 1 template0        6        FALSE
> 2 template1        6         TRUE
> [1] TRUE
  Running 'openSendQuery.R' [0s]
  Comparing 'openSendQuery.Rout' to 'openSendQuery.Rout.save' ...68a69,76
> create temp table tmptest with dbGetQuery
> [1] f1
> <0 rows> (or 0-length row.names)
> create temp table tmptest with dbSendQuery
> [1] f2
> <0 rows> (or 0-length row.names)
> PASS tmptest disappeared after disconnection
> [1] TRUE
  Running 'selectWithAlias.R' [0s]
  Comparing 'selectWithAlias.Rout' to 'selectWithAlias.Rout.save' ...53a54,66
>      ar      pe        sh    pr
> 1  4990 2791.90 0.0903296   6.3
> 2  7002 3892.60 0.1486220   6.3
> 3  7558 3930.66 0.1833120   6.3
> 4  7352 3869.32 0.1170630   6.3
> 5  7943 3948.54 0.1224170  17.1
> 6  7979 4010.15 0.1670450  17.1
> 7  9333 4345.75 0.1896510  17.1
> 8  8209 4344.75 0.1641270  17.1
> 9  8393 3682.04 0.2036540 119.0
> 10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
  Running 'utf.R' [0s]
  Comparing 'utf.Rout' to 'utf.Rout.save' ...67c67,70
< Skip because envirinmental variables are not set to tell the connection params.
---
> GOOD -- all encoding are as expected
> GOOD -- all encoding are as expected
> GOOD -- all encoding are as expected
> DONE