* using log directory 'd:/Rcompile/CRANpkg/local/3.6/RPostgreSQL.Rcheck'
* using R version 3.6.3 (2020-02-29)
* using platform: x86_64-w64-mingw32 (64-bit)
* using session charset: ISO8859-1
* checking for file 'RPostgreSQL/DESCRIPTION' ... OK
* this is package 'RPostgreSQL' version '0.6-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 hidden files and directories ... OK
* checking for portable file names ... OK
* checking whether package 'RPostgreSQL' can be installed ... OK
* checking installed package size ... OK
* checking package directory ... OK
* checking DESCRIPTION meta-information ... OK
* checking top-level files ... NOTE
Found a 'configure.in' file: 'configure.ac' has long been preferred.
* 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
* 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
** checking loading without being on the library search path ... OK
** checking use of S3 registration ... 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 loading without being on the library search path ... OK
** checking use of S3 registration ... 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 ... [5s] 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 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 include directives in Makefiles ... NOTE
Found the following Makefile(s) with an include directive with a pathname using R_HOME:
  src/libpq/Makefile.win
Even though not recommended, variable R_HOME may contain spaces.
Makefile directives use space as a separator and there is no portable
way to quote/escape the space in Make rules and directives.  However,
one can and should quote pathnames when passed from Makefile to the
shell, and this can be done specifically when invoking Make recursively.
It is therefore recommended to use the Make '-f' option to include files
in directories specified using R_HOME.  This option can be specified
multiple times to include multiple Makefiles.  Note that 'Makeconf' is
included automatically into top-level makefile of a package.
More information can be found in 'Writing R Extensions'.
* checking pragmas in C/C++ headers and code ... OK
* checking compiled code ... OK
* checking examples ...
** running examples for arch 'i386' ... [2s] OK
** running examples for arch 'x64' ... [2s] OK
* checking for unstated dependencies in 'tests' ... OK
* checking tests ...
** running tests for arch 'i386' ... [25s] OK
  Running 'connectWithNull.R' [1s]
  Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ... OK
  Running 'createTableMixedCaseTest.R' [1s]
  Comparing 'createTableMixedCaseTest.Rout' to 'createTableMixedCaseTest.Rout.save' ... OK
  Running 'dataTypeTests.R' [1s]
  Comparing 'dataTypeTests.Rout' to 'dataTypeTests.Rout.save' ... OK
  Running 'dateTZ.R' [1s]
  Comparing 'dateTZ.Rout' to 'dateTZ.Rout.save' ... OK
  Running 'datetimeTests.R' [1s]
  Comparing 'datetimeTests.Rout' to 'datetimeTests.Rout.save' ... OK
  Running 'datetimestampwrite.R' [1s]
  Comparing 'datetimestampwrite.Rout' to 'datetimestampwrite.Rout.save' ... OK
  Running 'dbColumnInfo.R' [1s]
  Comparing 'dbColumnInfo.Rout' to 'dbColumnInfo.Rout.save' ...49a50
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for table "aa"
67,70d67
< > proc.time()
<    user  system elapsed 
<    0.68    0.10    0.85 
< NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for table "aa"
  Running 'dbExistsIssue.R' [1s]
  Comparing 'dbExistsIssue.Rout' to 'dbExistsIssue.Rout.save' ... OK
  Running 'dbExistsq.R' [1s]
  Comparing 'dbExistsq.Rout' to 'dbExistsq.Rout.save' ... OK
  Running 'dbExistsqc.R' [1s]
  Comparing 'dbExistsqc.Rout' to 'dbExistsqc.Rout.save' ... OK
  Running 'dbGetQueryParams.R' [1s]
  Comparing 'dbGetQueryParams.Rout' to 'dbGetQueryParams.Rout.save' ... OK
  Running 'dbListFields.R' [1s]
  Comparing 'dbListFields.Rout' to 'dbListFields.Rout.save' ... OK
  Running 'dbTransactionTests.R' [1s]
  Comparing 'dbTransactionTests.Rout' to 'dbTransactionTests.Rout.save' ... OK
  Running 'dbWriteTableFailTest.R' [1s]
  Comparing 'dbWriteTableFailTest.Rout' to 'dbWriteTableFailTest.Rout.save' ... OK
  Running 'dbWriteTableSchema.R' [1s]
  Comparing 'dbWriteTableSchema.Rout' to 'dbWriteTableSchema.Rout.save' ... OK
  Running 'dbWriteTableTest.R' [1s]
  Comparing 'dbWriteTableTest.Rout' to 'dbWriteTableTest.Rout.save' ... OK
  Running 'dbWriteTabletypes.R' [2s]
  Comparing 'dbWriteTabletypes.Rout' to 'dbWriteTabletypes.Rout.save' ... OK
  Running 'dbtemptable.R' [1s]
  Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ... OK
  Running 'escape.R' [1s]
  Comparing 'escape.Rout' to 'escape.Rout.save' ... OK
  Running 'loadDriverAndConnect.R' [1s]
  Comparing 'loadDriverAndConnect.Rout' to 'loadDriverAndConnect.Rout.save' ... OK
  Running 'openSendQuery.R' [1s]
  Comparing 'openSendQuery.Rout' to 'openSendQuery.Rout.save' ... OK
  Running 'selectWhereZero.R' [1s]
  Comparing 'selectWhereZero.Rout' to 'selectWhereZero.Rout.save' ... OK
  Running 'selectWithAlias.R' [1s]
  Comparing 'selectWithAlias.Rout' to 'selectWithAlias.Rout.save' ... OK
  Running 'unknowntype.R' [1s]
  Comparing 'unknowntype.Rout' to 'unknowntype.Rout.save' ... OK
** running tests for arch 'x64' ... [26s] OK
  Running 'connectWithNull.R' [1s]
  Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ... OK
  Running 'createTableMixedCaseTest.R' [1s]
  Comparing 'createTableMixedCaseTest.Rout' to 'createTableMixedCaseTest.Rout.save' ... OK
  Running 'dataTypeTests.R' [1s]
  Comparing 'dataTypeTests.Rout' to 'dataTypeTests.Rout.save' ... OK
  Running 'dateTZ.R' [1s]
  Comparing 'dateTZ.Rout' to 'dateTZ.Rout.save' ... OK
  Running 'datetimeTests.R' [1s]
  Comparing 'datetimeTests.Rout' to 'datetimeTests.Rout.save' ... OK
  Running 'datetimestampwrite.R' [1s]
  Comparing 'datetimestampwrite.Rout' to 'datetimestampwrite.Rout.save' ... OK
  Running 'dbColumnInfo.R' [1s]
  Comparing 'dbColumnInfo.Rout' to 'dbColumnInfo.Rout.save' ...49a50
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for table "aa"
67,70d67
< > proc.time()
<    user  system elapsed 
<    0.67    0.10    0.93 
< NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for table "aa"
  Running 'dbExistsIssue.R' [1s]
  Comparing 'dbExistsIssue.Rout' to 'dbExistsIssue.Rout.save' ... OK
  Running 'dbExistsq.R' [1s]
  Comparing 'dbExistsq.Rout' to 'dbExistsq.Rout.save' ... OK
  Running 'dbExistsqc.R' [1s]
  Comparing 'dbExistsqc.Rout' to 'dbExistsqc.Rout.save' ... OK
  Running 'dbGetQueryParams.R' [1s]
  Comparing 'dbGetQueryParams.Rout' to 'dbGetQueryParams.Rout.save' ... OK
  Running 'dbListFields.R' [1s]
  Comparing 'dbListFields.Rout' to 'dbListFields.Rout.save' ... OK
  Running 'dbTransactionTests.R' [1s]
  Comparing 'dbTransactionTests.Rout' to 'dbTransactionTests.Rout.save' ... OK
  Running 'dbWriteTableFailTest.R' [1s]
  Comparing 'dbWriteTableFailTest.Rout' to 'dbWriteTableFailTest.Rout.save' ... OK
  Running 'dbWriteTableSchema.R' [1s]
  Comparing 'dbWriteTableSchema.Rout' to 'dbWriteTableSchema.Rout.save' ... OK
  Running 'dbWriteTableTest.R' [1s]
  Comparing 'dbWriteTableTest.Rout' to 'dbWriteTableTest.Rout.save' ... OK
  Running 'dbWriteTabletypes.R' [1s]
  Comparing 'dbWriteTabletypes.Rout' to 'dbWriteTabletypes.Rout.save' ... OK
  Running 'dbtemptable.R' [1s]
  Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ... OK
  Running 'escape.R' [1s]
  Comparing 'escape.Rout' to 'escape.Rout.save' ... OK
  Running 'loadDriverAndConnect.R' [1s]
  Comparing 'loadDriverAndConnect.Rout' to 'loadDriverAndConnect.Rout.save' ... OK
  Running 'openSendQuery.R' [1s]
  Comparing 'openSendQuery.Rout' to 'openSendQuery.Rout.save' ... OK
  Running 'selectWhereZero.R' [1s]
  Comparing 'selectWhereZero.Rout' to 'selectWhereZero.Rout.save' ... OK
  Running 'selectWithAlias.R' [1s]
  Comparing 'selectWithAlias.Rout' to 'selectWithAlias.Rout.save' ... OK
  Running 'unknowntype.R' [1s]
  Comparing 'unknowntype.Rout' to 'unknowntype.Rout.save' ... OK
* checking PDF version of manual ... OK
* DONE
Status: 2 NOTEs