ChangeLog

2010-10-17  Dirk Eddelbuettel  <edd@debian.org>

	* DESCRIPTION: Release 0.1-7

2010-10-14  Tomoaki NISHIYAMA  <tomoakin@kenroku.asrc.kanazawa-u.ac.jp>

	* src/RS-PostgreSQL.c: nullOk column in dbColumnInfo to have NA
	unless the backend has clear statement

2010-10-13  Joe Conway  <joe@conway.com>

	* src/RS-PostgreSQL.c: Correct segfault from issue ticket #24

2010-10-13  Tomoaki NISHIYAMA  <tomoakin@kenroku.asrc.kanazawa-u.ac.jp>

	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  <edd@debian.org>

	* 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  <tomoakin@kenroku.asrc.kanazawa-u.ac.jp>

	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  <edd@debian.org>

	* 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  <edd@debian.org>

	* 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  <edd@debian.org>

	* 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  <edd@debian.org>

	* 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  <edd@debian.org>

	* R/PostgreSQL.R: Add missing paste() with thanks to João G.

2009-10-14  Dirk Eddelbuettel  <edd@debian.org>

	* tests/selectWhereZero.R: Fix upper/lower case table name

2009-10-13  Dirk Eddelbuettel  <edd@debian.org>

	* 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  <edd@debian.org>

	* 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  <edd@debian.org>

	* 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  <edd@debian.org>

	* DESCRIPTION: CRAN release 0.1-2

	* tests/*: Even more small fixes

	* configure.win: Test for $PG_HOME

2008-10-28  Dirk Eddelbuettel  <edd@debian.org>

	* DESCRIPTION: CRAN release 0.1-1

	* tests/*: More cleanup on the tests

	* DESCRIPTION: URL fix

2008-10-21  Dirk Eddelbuettel  <edd@debian.org>

	* 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  <edd@debian.org>

	* DESCRIPTION: Initial CRAN release 0.1-0