• using R Under development (unstable) (2012-05-22 r59401)
• using platform: x86_64-unknown-linux-gnu (64-bit)
• using session charset: UTF-8
• checking for file ‘RPostgreSQL/DESCRIPTION’ ... OK
• this is package ‘RPostgreSQL’ version ‘0.3-2’
• 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 whether package ‘RPostgreSQL’ can be installed ... OK
• checking installed package size ... OK
• checking package directory ... OK
• checking for portable file names ... OK
• checking for sufficient/correct file permissions ... OK
• checking DESCRIPTION meta-information ... OK
• checking top-level 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 for unstated 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 ... OK
• checking Rd files ... 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 C/C++/Fortran sources/headers ... OK
• checking line endings in Makefiles ... OK
• checking for portable compilation flags in Makevars ... OK
• checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK
• checking compiled code ... OK
• checking sizes of PDF files under ‘inst/doc’ ... OK
• checking installed files from ‘inst/doc’ ... OK
• checking examples ... OK
• checking for unstated dependencies in tests ... OK
• checking tests ... [16s/29s] OK
  Running ‘connectWithNull.R’
  Comparing ‘connectWithNull.Rout’ to ‘connectWithNull.Rout.save’ ...41,42d40
  < <PostgreSQLConnection:(21043,0)>
  < [1] TRUE
  Running ‘createTableMixedCaseTest.R’
  Comparing ‘createTableMixedCaseTest.Rout’ to ‘createTableMixedCaseTest.Rout.save’ ...87,94d86
  < 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’
  Comparing ‘dataTypeTests.Rout’ to ‘dataTypeTests.Rout.save’ ...116,125d115
  < 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 ‘datetimeTests.R’
  Comparing ‘datetimeTests.Rout’ to ‘datetimeTests.Rout.save’ ...66,96d65
  <
  <
  < **** 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 timestamp with time zone
  < 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 TIMESTAMPTZOID 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’
  Running ‘dbColumnInfo.R’
  Comparing ‘dbColumnInfo.Rout’ to ‘dbColumnInfo.Rout.save’ ...49,60d48
  < NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for table "aa"
  < dbColumnInfo
  < name Sclass type len precision scale nullOK
  < 1 pk integer INTEGER 4 -1 -1 FALSE
  < 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’
  Comparing ‘dbExistsIssue.Rout’ to ‘dbExistsIssue.Rout.save’ ...57,60d56
  < Does rockdata exist? [1] TRUE
  < Does public.rockdata exist? [1] FALSE
  < [1] "Removing rockdata\n"
  < [1] TRUE
  Running ‘dbExistsq.R’
  Comparing ‘dbExistsq.Rout’ to ‘dbExistsq.Rout.save’ ...58,62d57
  < Write rock'data
  < Does rock'data exist? [1] TRUE
  < Does "public.rock'data" exist? [1] FALSE
  < Removing rock'data
  < [1] TRUE
  Running ‘dbExistsqc.R’
  Running ‘dbListFields.R’
  Running ‘dbWriteTableFailTest.R’
  Running ‘dbWriteTableSchema.R’
  Running ‘dbWriteTableTest.R’
  Comparing ‘dbWriteTableTest.Rout’ to ‘dbWriteTableTest.Rout.save’ ...53,65d52
  < 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’
  Running ‘dbtemptable.R’
  Comparing ‘dbtemptable.Rout’ to ‘dbtemptable.Rout.save’ ...49,51d48
  < name
  < 1 bar
  < PASS -- ended without segmentation fault
  Running ‘escape.R’
  Comparing ‘escape.Rout’ to ‘escape.Rout.save’ ...43,45d42
  < [1] "aaa"
  < [1] "aa''a"
  < [1] TRUE
  Running ‘loadDriverAndConnect.R’
  Comparing ‘loadDriverAndConnect.Rout’ to ‘loadDriverAndConnect.Rout.save’ ...40,43d39
  < datname encoding datallowconn
  < 1 template0 6 FALSE
  < 2 template1 6 TRUE
  < [1] TRUE
  Running ‘selectWhereZero.R’
  Comparing ‘selectWhereZero.Rout’ to ‘selectWhereZero.Rout.save’ ...56,67d55
  < Error in postgresqlExecStatement(conn, statement, ...) :
  < RS-DBI driver: (could not Retrieve the result : ERROR: operator does not exist: text = integer
  < LINE 1: select * from tmpirisdata where "Species"=0
  < ^
  < HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  < )
  < NULL
  < [1] "Removing tmpirisdata\n"
  < PASS: reached to the end of the test code without segmentation fault
  < Warning message:
  < In postgresqlQuickSQL(conn, statement, ...) :
  < Could not create executeselect * from tmpirisdata where "Species"=0
  Running ‘selectWithAlias.R’
  Comparing ‘selectWithAlias.Rout’ to ‘selectWithAlias.Rout.save’ ...54,66d53
  < 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
• checking PDF version of manual ... OK