* using log directory 'd:/Rcompile/CRANpkg/local/2.13/RPostgreSQL.Rcheck' * using R version 2.13.2 (2011-09-30) * using platform: i386-pc-mingw32 (32-bit) * using session charset: ISO8859-1 * 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 whether package 'RPostgreSQL' can be installed ... OK * checking installed package size ... OK * checking package directory ... OK * checking for portable file names ... 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 * loading checks for arch 'i386' ** 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 * loading checks for arch 'x64' ** 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 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 sizes of PDF files under inst/doc ... OK * checking examples ... ** running examples for arch 'i386' ... OK ** running examples for arch 'x64' ... OK * checking for unstated dependencies in tests ... OK * checking tests ... ** running tests for arch 'i386' OK Running 'connectWithNull.R' Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...41,42d40 < < [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,59d48 < 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 61d49 < HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index »aa_pkey« für Tabelle »aa« 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 24 FALSE < 2 template1 24 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 : FEHLER: Operator existiert nicht: text = integer < LINE 1: select * from tmpirisdata where "Species"=0 < ^ < HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. < ) < 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 ** running tests for arch 'x64' OK Running 'connectWithNull.R' Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...41,42d40 < < [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,59d48 < 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 61d49 < HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index »aa_pkey« für Tabelle »aa« 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 24 FALSE < 2 template1 24 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 : FEHLER: Operator existiert nicht: text = integer < LINE 1: select * from tmpirisdata where "Species"=0 < ^ < HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. < ) < 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