2024-01-11 Tomoaki NISHIYAMA * Supply (void) for a testprogram in configure.ac for warning by clang 2024-01-10 Tomoaki NISHIYAMA * Fix partial match warning #132 * Suppress warnings on win-devel 2023-12-15 Tomoaki NISHIYAMA * %s format string for an integer in an error message was corrected * exclude dropped column from column listing (reported by warnes #130) 2023-01-12 Tomoaki NISHIYAMA * replace sprintf with snprintf * replace strcpy with strncpy 2021-07-26 Tomoaki NISHIYAMA * Change LICENCE to GPL-3 * import new config.guess and config.sub * Drop an unused variable RS_PostgreSQL_closeManager_t * Use seq_along() instead of seq(along=) * -Wno-stringop-truncation for libpq compilation on windows * Change Description for new version and license. * fix type as pointed out by PR #109 * http to https transition for URLs 2017-06-19 Tomoaki NISHIYAMA * new libpq from postgresql-9.6.3 and Makefiles generated on Sierra (macOS 10.12) 2014-02-08 Tomoaki NISHIYAMA Update tests docs for CRAN submission. A bug in postgresqlNewConnection() was identified and fixed during the test rewrite. * inst/ANNOUNCEMENT * inst/NEWS * man/dbConnect-methods.Rd: explanation of the parameters. * R/PostgreSQLSupport.R: newConnection do not emit error on NULL argument but convert to empty string which is a valid value. * src/RS-PostgreSQL.c: RS_PostgreSQL_newConnection() don't checkk for empty string. * tests: Write more appropriate comments. Tell when the test is skipped. 2014-02-06 Tomoaki NISHIYAMA * config.sub, config.guess, install-sh move to src subdirectory * man/postgresqlBuildTableDefinition.Rd: Shorten usage line * man/postgresqlSupport.Rd: Shorten usage line 2014-02-04 Tomoaki NISHIYAMA * ChangeLog * inst/News * src/libpq: update to libpq from postgresql-9.3.2 * configure.in: change the condition to use accompanied libpq * configure * tests/bytea.R: test both standard_conforming_strings states; add PASS response 2014-01-30 Tomoaki NISHIYAMA Support hex conversion for unescaping. Prevent segfault on unknown type to dbWriteTable. Add minimal description of the escapebytea and unescapebytea. * ChangeLog * man/postgresqlSupport.Rd * src/RS-PQescape.c * src/RS-pgsql-copy.c * R/PostgreSQLSupport.R: separate message body from heading * tests/bytea.R: remove E prefix for postgresql version 9, though this cause warning on 8.X. * DESCRIPTION: forward the version to 0.5-1 * R/PostgreSQL.R: forward the version to 0.5-1 2014-01-29 Tomoaki NISHIYAMA Initial support for Bytea data type. * ChangeLog * src/RS-PQescape.c * R/PostgreSQLSupport.R * NAMESPACE * tests/bytea.R 2013-11-12 Tomoaki NISHIYAMA Prepare for release * inst/NEWS * man/postgresqlBuildTableDefinition.Rd: line length * man/postgresqlSupport.Rd: line length 2013-10-27 Tomoaki NISHIYAMA Strange path support for OS X 10.9 Marvericks * configure.in * configure * src/RS-PostgreSQL.c: keep declaration on the top of a block. 2013-08-22 Tomoaki NISHIYAMA Memory leak detected by valgrind. * src/RS-PostgreSQL.c * src/RS-pgsql-copy.c * src/RS-pgsql-getResult.c * src/RS-pgsql-pqexec.c * src/RS-pgsql-pqexecparams.c 2013-06-21 Tomoaki NISHIYAMA * postgresqlWriteTable: send column names at COPY; * dbWriteTableTest.R: test for append=T 2013-06-12 Tomoaki NISHIYAMA Close the socket on failure of opening connection * src/RS-PostgreSQL.c 2013-03-27 Tomoaki NISHIYAMA Document synchronization and testoutputs. * man/postgresqlSupport.Rd 2013-03-27 Tomoaki NISHIYAMA Change notation of LICENSE in DESCRIPTION upon request from CRAN * LICENSE * inst/NEWS * inst/ANNOUNCEMENTS * inst/TODO 2013-03-27 Tomoaki NISHIYAMA Use system libpq library when available on OS X (darwin) * src/configure.in * src/configure 2012-12-06 Tomoaki NISHIYAMA Test implementation of SQL with parameters. * R/PostgreSQLSupport.R * src/RS-pgsql-pqexecparams.c * tests/dbGetQueryParams.R 2012-10-04 Tomoaki NISHIYAMA Bug fix for GC related errro as reported as issue 42. * src/RS-DBI.c * src/RS-PostgreSQL.c * tests/dbColumnInfo.R 2012-09-18 Tomoaki NISHIYAMA Keep consistency of const modifier to const char* * src/RS-DBI.c 2012-09-18 Tomoaki NISHIYAMA Suppress message when $R_OS_TYPE is unset * configure * configure.in 2012-04-06 Tomoaki NISHIYAMA For issue 39: use a single equal sign (=) in test string comparison * configure * configure.in 2012-03-28 Tomoaki NISHIYAMA Avoid connection cloning. Ensure that BEGIN transaction is meaningfull * R/PostgreSQLSupport.R * tests/openSendQuery.R * tests/dbTransactionTests.R * tests/openSendQuery.R * man/dbCommit-methods.Rd 2012-02-27 Tomoaki NISHIYAMA Suppress dbColumnInfo Segmentation fault. RS_DBI_getTypeName() return "UNKNOWN" instead of NULL pointer. * src/RS-DBI.h * src/RS-DBI.c * tests/unknowntypes.R 2012-01-10 Tomoaki NISHIYAMA Windows support for r-devel. Make libpq.a with ar directly from $(OBJ) not via dll. Thus, install.libs.R is no more required. * ChangeLog * DESCRIPTION * src/Makevars.win * src/install.libs.R: delete * src/libpq/Makefile.global.win64 * src/libpq/Makefile.win * src/libpq/Makefile.shlib 2011-12-31 Tomoaki NISHIYAMA Move conditionals from Makevars.in to configure.in and configure so that the GNU extension is not used. * ChangeLog * DESCRIPTION * configure * configure.in * src/Makevars.in 2011-12-29 Tomoaki NISHIYAMA Prepare for release. As the last update makes many incompatibilities, the version number is large update. Remove dbBeginTransaction which is not defined in DBI. * ChangeLog * DESCRIPTION * NAMESPACE * R/PostgreSQL.R * inst/NEWS * man/dbCommit-methods.Rd 2011-12-03 Tomoaki NISHIYAMA Remove exported names that are not defined in DBI and may conflict other packages. Remove safe.write, which is not used anymore. Don't use make.db.names, which prevents using natural names. Move dbBuildTableDefinition to postgresqlBuildTableDefinition. Move isIdCurrent to isPostgresqlIdCurrent row.names be integer rather than charactor for sqldf compatibility. * NAMESPACE * R/PostgreSQL.R * R/PostgreSQLSupport.R * R/dbObjectId.R * man/safe.write.Rd * man/dbBuildTableDefinition.Rd * man/postgresqlBuildTableDefinition.Rd * man/make.db.names-methods.Rd * man/dbObjectId-class.Rd * man/isIdCurrent.Rd * man/isPostgresqlIdCurrent.Rd * man/postgresqlSupport.Rd 2011-12-02 Tomoaki NISHIYAMA Add clean: target to clean the libpq subdir on darwin * src/Makevars.in 2011-11-24 Tomoaki NISHIYAMA Use internal libpq for Mac OS X without PostgreSQL installation * config.guess * config.sub * configure * configure.in * install-sh * Makevars.in * src/libpq/netdb.h * src/libpq/pwd.h 2011-11-22 Tomoaki NISHIYAMA Restructuring libpq directory so that the dynamic library for Mac OS X / darwin can be made with make -f Makefile.darwin in that directory. Move windows specific include files to wininclude/ so that they do not interfere darwin. Configuration dependent files are separated as *.win and *.darwin and that should be copied at the first step of make. This is not enabled in OS X, though. * ChangeLog * src/Makevars.win * src/libpq * src/libpq/getaddrinfo.c: MinGW-w64 compatibility * src/libpq/pg_config_os.h.win: MinGW-w64 compatibility 2011-11-16 Tomoaki NISHIYAMA add LICENSE file * ChangeLog * inst/NEWS: Change the release date. * LICENSE 2011-11-15 Tomoaki NISHIYAMA Edit DESCRIPTION for LICENSE format, Copyright notice, and requirements for installation. * DESCRIPTION 2011-11-14 Tomoaki NISHIYAMA Remove make 3.80 dependency, so that the library can be compiled with Rtools214 without newer MinGW/MSYS installation. * ChangeLog * src/libpq/.gitignore: remove * src/libpq/Makefile.global.win32: remove recursion support * src/libpq/Makefile.global.win64: remove recursion support * src/libpq/Makefile.shlib: remove '| $(SHLIB_PREREQS)' 2011-11-12 Tomoaki NISHIYAMA Bundle libpq source for compilation on windows. * libpq/: src/interfaces/libpq from postgresql-9.1.1 configured on MinGW-w64 environment with some additional files required and Makefile edited to remove reference to other paths. Makefile.global.win32 is from postgesql-9.1.1 configured on MinGW 32-bit envionment. * configure.win: not depending on PG_HOME on windows. * src/Makevars.win: depend on libpq/ * src/install.libs.R: derived from R-2.14.0/src/library/tools/R copy libpq/libpq.dll to the destination same as RPostgreSQL.dll. 2011-10-03 Tomoaki NISHIYAMA Use try() not to abort on error to write spacial/kanji characters. For control characters use print again, but not for kanji special latin characters as umlaut. * ChangeLog * DESCRIPTION: Change maintainer name & address * tests/dbWriteTabletypes.R: use try() 2011-10-02 Tomoaki NISHIYAMA Avoid using raw UTF-8 string and conversion by print() for the test. * tests/dbWriteTabletypes.R: use \uxxxx escape for utf-8 string and use cat() to output them. 2011-10-01 Dirk Eddelbuettel Added $Id$ to all .R .c .h files and removed $Date$ from them. Removed declared-but-unused variables. 2011-09-26 Tomoaki NISHIYAMA Raise the version number to 0.2-0 * ChangeLog * DESCRIPTION * R/PostgreSQL.R 2011-09-25 Dirk Eddelbuettel * tests/*Rout.save: Updated six reference output files to match current output, differences mostly in whitespace or formatting 2011-09-25 Tomoaki NISHIYAMA Type conversion: integer is mapped to integer in postgresql; * R/PostgreSQLSupport.R: code change * tests/dbWriteTabletypes.R: testcode that R integer stored to PostgreSQL gets back as integer in R. 2011-09-25 Tomoaki NISHIYAMA dbListFields see only the current_schema unless the schema is specified * R/PostgreSQL.R: dbListFields are changed as above * tests/dbListFields.R: testcase 2011-09-24 Tomoaki NISHIYAMA Remove warning on enum, array, macaddr and inet; they are just kept as string, though. * src/RS-PostgreSQL.c: code change * man/dbSendQuery-methods.Rd: mannual 2011-08-26 Tomoaki NISHIYAMA dbWriteTable does escape strings, without a temporary file * NAMESPACE: export postgresqlCopyInDataframe * R/PostgreSQLSupport.R: adapter postgresqlCopyInDataframe * man/postgresqlSupport.Rd: document * src/RS-pgsql-copy.c: major code change; some derive from R * src/S4R.h: include "R.h" 2011-03-11 Dirk Eddelbuettel added a short paragraph to DESCRIPTION reminding people to install PostgreSQL itself * DESCRIPTION 2011-03-07 Tomoaki NISHIYAMA dbSendQuery when the return value is not to be used. Use dbGetQeury instead. * tests/createTableMixedCaseTest.R * tests/dataTypeTests.R * tests/datetimeTests.R * tests/dbColumnInfo.R * tests/dbtemptable.R 2011-03-07 Tomoaki NISHIYAMA Support for writing Date and POSIXct class as date and timestamp with time zone Manual and code consistency for postgresqlQuoteId and postgresqlTableRef. * R/PostgreSQLSupport.R: add field type for Date and POSIXct for PostgreSQL * tests/datetimestampwrite.R: the test for above * R/PostgreSQLSupport.R: identifier -> identifiers * man/postgresqlSupport.Rd: explict that one or more identifiers can be passed to postgresqlQuoteId 2011-03-06 Tomoaki NISHIYAMA More handling schema. * R/PostgreSQL.R: dbRemoveTable handle c("schema", "table"). 2011-03-05 Tomoaki NISHIYAMA Handling of schema: postgresqlTableRef generates "schema"."table" from a vector c("schema", "table"), and many of postgresqlQuoteId was changed to postgresqlTableRef. * NAMESPACE: exporting postgresqlQuoteId, postgresqlTableRef * R/PostgreSQLSupport.R: the code changed * man/postgresqlSupport.Rd: documentation change * R/PostgreSQL.R: dbExistsTable accept c("schema", "table") * tests/dbExistsqc.R: test for "rock.data" * tests/dbWriteTableSchema.R: tests dbWritetable to c("public", "rockdata") 2010-11-13 Tomoaki NISHIYAMA Consistency of tablename argument of dbExistsTable and dbWriteTable. * R/PostgreSQL.R: dbExistsTable behave like dbWriteTable on table name. * tests/dbExistsqc.R: test code 2010-11-02 Tomoaki NISHIYAMA Get results after CopyIn so that error is raised when incompatible table exists for dbWriteTable(append=TRUE) * NAMESPACE: exporting postgresqlEscapeStrings * R/PostgreSQLSupport.R: call sequence change for dbWriteTable: pqExec, CopyIn, and getResult * src/RS-RS-pgsql-getResult.c: new function to get return results. * src/RS-RS-pgsql-pqexec.c: new function to call pqexec. * man/postgresqlSupport.Rd: documentation * tests/dbWriteTableFailTest.R: New test code 2010-10-17 Dirk Eddelbuettel * DESCRIPTION: Release 0.1-7 2010-10-14 Tomoaki NISHIYAMA * src/RS-PostgreSQL.c: nullOk column in dbColumnInfo to have NA unless the backend has clear statement 2010-10-13 Joe Conway * src/RS-PostgreSQL.c: Correct segfault from issue ticket #24 2010-10-13 Tomoaki NISHIYAMA postgresqlEscapeStrings and postgresqlQuoteId to escape and quote strings and identifiers. This is used in dbWriteTable, dbExitsTable, and dbRemoveTable. * NAMESPACE: exporting postgresqlEscapeStrings * R/PostgreSQL.R: use postgresqlEscapeStrings and postgresqlQuoteId in dbExistsTable and dbRemoveTable * R/PostgreSQLSupport.R: define postgresqlQuoteId * src/RS-PQescape.c: implements postgresqlEscapeStrings, which is adapter to PQescapeStringConn * tests/createTableMixedCaseTest.R: modified what is the right behavior * tests/escape.R: test for postgresqlEscapeStrings * tests/dbExistsq.R: test for dbExistsTable with complex name * tests/selectWhereZero.R: Change species to "Species" so that the error message will not change. 2010-10-12 Dirk Eddelbuettel * src/RS-DBI.h: Applied patch by Brian D. Ripley to correct declaration of getpid() on Windows * ChangeLog: Moved from inst/ChangeLog; now C-x 4 a inserts filenames 2010-10-05 Tomoaki NISHIYAMA dbWriteTable copies tha data via the network connection * R/PostgreSQLSupport.R: postgresqlCopyIn, adapter to RS_PostgreSLQ_copyin * src/RS-pgsql-copy.c: implements RS_PostgreSQL_copyin, adapter to PQputCopyData and PQputCopyEnd * src/RS-PostgreSQL.c: initialize is_select * src/RS-PostgreSQL.h: decleration of RS_PostgreSQL_copyin * NAMESPACE: decleration 2010-09-11 Dirk Eddelbuettel * src/RS-DBI.h: Applying patch by tomoakin@kenroku.kanazawa-u.ac.jp from Issue #21 to add missing unistd.h to help with Intel compiler 2010-07-14 Dirk Eddelbuettel * R/PostgreSQLSupport.R: In postgresqlFetch(), correct case of as.POSIXct() call where format string is passed to tz argument Thanks to Steve Eick for the bug report. 2009-11-05 Dirk Eddelbuettel * R/PostgreSQLSupport.R: Apply patch by Robert McGehee to avoid the default tmpdir not only on Linux but also Darwin 2009-10-19 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-6 * tests/connectWithNull.R: allow for port to be passed via an env. var. * tests/dataTypeTests.R: idem * tests/datetimeTests.R: idem * tests/dbExistsIssue.R: idem * tests/dbWriteTableTest.R: idem * tests/loadDriverAndConnect.R: idem * tests/selectWhereZero.R: idem * tests/selectWithAlias.R: idem 2009-10-16 Dirk Eddelbuettel * R/PostgreSQL.R: Add missing paste() with thanks to João G. 2009-10-14 Dirk Eddelbuettel * tests/selectWhereZero.R: Fix upper/lower case table name 2009-10-13 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-5 + No new features but fixes for bugs #1, #2, #3 and #6 on the issue tracker + Both #4 and #5 are feature / enhancement request for which patch contributions are greatly appreciated. + Lastly #7 cannot be replicated. [ Neil Tiffin ] * configure.in: Added standard OS X / Fink location * src/RS-DBI.*: Consistent formatting via use of GNU indent * src/RS-PostgreSQL.*: idem * src/S4R.h: idem [ Dirk Eddelbuettel ] * src/RS-PostgreSQL.c: Apply fix by Joe Conway for seg.fault on alias'ed queries report as issue #1 in the issue tracker. * src/RS-PostgreSQL.c: Remove unused variables * R/PostgresSQL.R: Correction to dbExistsTable() to also recognise queries of the form 'schemaname.tablename' which was reported as issue #3 in the issue tracker following earlier emails by Prasenjit Kapat -- thanks to Prasenjit and Joe Conway patches that I merged * R/PostgreSQLSupport.R: In dbConnect(), stop if any one of user, password, host, dbname, port or tty is NULL to prevent a seg.fault which was reported as issue #2 on the issue tracker * R/PostgreSQLSupport.R: Wrap dbSendQuery() in try() to be more fault-tolerant an queries with errors which was reported as issue #6, thanks to Joe Conway for the suggested fix. * man/dbApply.Rd: Commented-out \usage thanks to new Rd parser * man/safe.write.Rd: Fixed cross-references thanks to R 2.10.0 parser * man/PostgreSQL.Rd: idem * man/dbReadTable-methods.Rd: idem * R/dbObjectId.R: Set missing SVN property Date * R/S4R.R: idem * tests/connectWithNull.*: added new test and comparison output * tests/dbExistsIssue.*: idem * tests/dbWriteTable.*: idem * tests/selectWhereZero.*: idem * tests/selectWithAlias.*: idem * tests/dataTypeTests.R: Remove correct temp. table 2009-01-26 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-4 * man/dbDataType-methods.Rd: small correction for error noticed by the new R parser 2008-12-12 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-3 * src/RS-DBI.c: Fixed to small memory leaks, with thanks to Jeff Horner for a small patch to which we added a similar fix * tests/*: Corrected a small typo in env.var 2008-11-02 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-2 * tests/*: Even more small fixes * configure.win: Test for $PG_HOME 2008-10-28 Dirk Eddelbuettel * DESCRIPTION: CRAN release 0.1-1 * tests/*: More cleanup on the tests * DESCRIPTION: URL fix 2008-10-21 Dirk Eddelbuettel * tests/*: Tests are now run if and only if the environment variables POSTGRES_USER, POSTGRES_HOST and POSTGRES_DATABASE are set; the variable POSTGRES_PASSWD is also used. This allows tests to run if the local admin wants them to run. Thanks to Uwe Ligges for the idea, and to Brian Ripley for supporting it. For now, CRAN won't run this though and it is effectively disabled in the default test during 'R CMD check' as the vars will presumably not be set. * configure{,.in}: no longer test for libpq.so as a second confirmation as OS X has it as libpq.dylib and would hence always fail. Thanks to Jan de Leeuw for the pointer. 2008-10-14 Dirk Eddelbuettel * DESCRIPTION: Initial CRAN release 0.1-0