• using R version 4.2.0 (2022-04-22)
  • using platform: x86_64-apple-darwin17.0 (64-bit)
  • using session charset: UTF-8
  • checking for file ‘RPostgreSQL/DESCRIPTION’ ... OK
  • this is package ‘RPostgreSQL’ version ‘0.7-5’
  • checking package namespace information ... OK
  • checking package dependencies ... OK
  • checking if this is a source package ... OK
  • checking if there is a namespace ... OK
  • checking for executable files ... OK
  • checking for hidden files and directories ... OK
  • checking for portable file names ... OK
  • checking for sufficient/correct file permissions ... OK
  • checking whether package ‘RPostgreSQL’ can be installed ... [13s/17s] OK
    See the install log for details.
  • checking installed package size ... OK
  • checking package directory ... OK
  • checking DESCRIPTION meta-information ... OK
  • checking top-level files ... OK
  • checking for left-over files ... OK
  • checking index information ... OK
  • checking package subdirectories ... OK
  • checking R files for non-ASCII characters ... OK
  • checking R files for syntax errors ... OK
  • checking whether the package can be loaded ... OK
  • checking whether the package can be loaded with stated dependencies ... OK
  • checking whether the package can be unloaded cleanly ... OK
  • checking whether the namespace can be loaded with stated dependencies ... OK
  • checking whether the namespace can be unloaded cleanly ... OK
  • checking loading without being on the library search path ... OK
  • checking dependencies in R code ... OK
  • checking S3 generic/method consistency ... OK
  • checking replacement functions ... OK
  • checking foreign function calls ... OK
  • checking R code for possible problems ... [3s/3s] OK
  • checking Rd files ... [1s/1s] OK
  • checking Rd metadata ... OK
  • checking Rd cross-references ... OK
  • checking for missing documentation entries ... OK
  • checking for code/documentation mismatches ... OK
  • checking Rd \usage sections ... OK
  • checking Rd contents ... OK
  • checking for unstated dependencies in examples ... OK
  • checking line endings in shell scripts ... OK
  • checking line endings in C/C++/Fortran sources/headers ... OK
  • checking line endings in Makefiles ... OK
  • checking compilation flags in Makevars ... OK
  • checking for GNU extensions in Makefiles ... OK
  • checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK
  • checking use of PKG_*FLAGS in Makefiles ... OK
  • checking include directives in Makefiles ... OK
  • checking compiled code ... OK
  • checking examples ... [1s/1s] OK
  • checking for unstated dependencies in ‘tests’ ... OK
  • checking tests ... [6s/7s] OK
      Running ‘connectWithNull.R’ [0s/0s]
      Comparing ‘connectWithNull.Rout’ to ‘connectWithNull.Rout.save’ ...40a41,42
    > <PostgreSQLConnection>
    > [1] TRUE
      Running ‘createTableMixedCaseTest.R’ [0s/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’ [0s/0s]
      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’ [0s/0s]
      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/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/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/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/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/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/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/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’ [0s/0s]
      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/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/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/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/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/0s]
      Comparing ‘dbtemptable.Rout’ to ‘dbtemptable.Rout.save’ ...48a49,51
    > name
    > 1 bar
    > PASS -- ended without segmentation fault
      Running ‘escape.R’ [0s/0s]
      Comparing ‘escape.Rout’ to ‘escape.Rout.save’ ...42a43,45
    > [1] "aaa"
    > [1] "aa''a"
    > [1] TRUE
      Running ‘loadDriverAndConnect.R’ [0s/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/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/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/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
  • checking PDF version of manual ... OK
  • DONE
    Status: OK
  • using check arguments '--no-clean-on-error '