Module Name:	pkgsrc
Committed By:	jwise
Date:		Fri Apr  8 14:35:08 UTC 2005

Modified Files:
	pkgsrc/databases/p5-DBD-postgresql: Makefile

Log Message:
Update to version 1.41.  Changes since 1.22 (the last pkgsrc version):

1.41
	- ('Greg' is Greg Sabino Mullane, greg@turnstep.com)
	- Make sure tests remove all temporary tables.
		[Frank Bax]
	- Preserve sqlstate if rolling back on deallocate, fix
		potential segfault. [Stephen Clouse]
	- Fix CPAN bug #12004: commit and rollback now return true
		[Greg] (thanks to ivan-dbdpg@420.am)
	- Overhaul and update COPY support; use new protocol.
		New dbh methods: pg_putline, pg_getline, pg_endcopy.
		[Greg]
	- Rewrote version detection code. Compiled version and target
		version are now available via $dbh->{pg_lib_version} and
		$dbh->{pg_server_version} [Greg]
	- Set our default type_id to 0, not 1043 (VARCHAR) when possible.
		Suggested by Abhijit Menon-Sen via David Wheeler. [Greg]
	- Add $dbh methods pg_savepoint(), pg_rollback_to(), and pg_release()
		[Stephen Clouse] [Greg]
1.40 Tue Feb 22 06:06:45 UTC 2005
	- Raise required DBI version to 1.38
	- Execute returns 0 (0E0) not -1 for successful DDL commands.
		[Robert Treat]
	- Change all string lengths to use STRLEN
		[rink@stack.nl]
	- Added $dbh->pg_server_trace($fh) [Greg Sabino Mullane]
	- Added $dbh->{pg_errorlevel}. [Greg Sabino Mullane]
	- Fix utf8 quote() support [Dominic Mitchell <dom@semantico.com>]
	- Added explicit support for types SQL_BOOLEAN, DATE, TIME,
		TIMESTAMP, and TIMESTAMPTZ. Return correct values for
		DATEOID and TIMEOID. [Greg Sabino Mullane]
	- Added tablespace support for table_info and primary_key_info.
		[Greg Sabino Mullane]
	- Added new attributes to $dbh: pg_db, pg_user, pg_pass,
		pg_host, pg_port, pg_options, pg_socket, pg_pid
		[Greg Sabino Mullane]
	- Minor fixes in quote.c, dbdimp.c, and types.h
		[Christophe Martin: schplurtz at free.fr]
	- Added support for SQLSTATE via $dbh->state and $sth->state
		[Greg Sabino Mullane]
	- Major overhaul of prepare/execute to handle new server-side
		prepare system. See Pg.pm for details. [Greg Sabino Mullane]
	- Make the tests honor the DBD_SCHEMA variable instead of
		assuming that the "public" schema is available.
		[Rainer Weikusat]
	- dbdimp.c cleanups: better error messages, ensure commit
		is only called once after a transaction fails.
		[Alexey Slynko]
	- primary_key() returns empty list not undef if no match.
		[Julian Mehnle]
	- Added the pg_protocol database handle attribute
		[Greg Sabino Mullane]
	- Changed "noprefix" to pg_noprefix
1.32 Wed Feb 25 18:24:18 UTC 2004
	- Bugfix for memory allocation problems on win systems
		[Rafael Kitover <caelum@debian.org>]
	- Rewrote the foreign_key_info() method to handle
		multi-column keys. [Greg Sabino Mullane]
	- Rewrote the primary_key_info() and primary_key() methods to
		cleanly handle multi-column primary keys. Also added a "pg_onerow"
		attribute to allow primary_key_info() to return a single
		row containing multiple-column information. [Greg Sabino Mullane]
	- Switched commit behavior from commit->execute->begin
		to begin->execute->commit
		[xelah-junk@xelah.com]
	- Made the _pg_use_catalog subroutine use {private_dbgpg}.
		(CPAN bug #4841) [Greg Sabino Mullane]
	- Changed strdup to safemalloc/strcpy in dbdimp.c
		(CPAN bug #4578) [anonymous CPAN user]
	- Made the data_sources method escape the database names as needed.
		Added support for databases with spaces in their names.
		[Greg Sabino Mullane]
	- Added the "noprefix" attribute to prevent the tables() method
		from prepending the schema name. [Greg Sabino Mullane]
	- Rewrote the testing suite. Many more tests are performed.
		Servers with a low client_min_messages are handled correctly.
		[Greg Sabino Mullane]
	- Fixed bug causing '$\d' to be picked up as a placeholder.
		(CPAN bug #4799) [Greg Sabino Mullane]
	- pg_notifies now catches and reports when PQconsumeInput fails.
		(CPAN bug #4027) [nmueller@cs.wisc.edu]
	- Enabled the "pg_bool_tf" database handle [Greg Sabino Mullane]
	- Added required fields to the type_info() method:
		SQL_DATA_TYPE, SQL_DATETIME_SUB, and INTERVAL PRECISION
		[Greg Sabino Mullane]
	- Fixed bug where the table_attributes() method was incorrectly
		removing the NULLABLE column. [Greg Sabino Mullane]
	- Fixed bug where case was not being preserved by the
		foreign_key_info() method [Greg Sabino Mullane]
	- a fetch on any column that had a type that did not have an entry
		in the type_info array would segfault DBD::Pg.
		(CPAN bugs #4818,4432) [Rudy Lippan]
	- Duplicate rows bug with column_info() REMARKS has been fixed. However,
		support for Postgres 7.1.x which worked briefly for 1.31 has now been
		dropped for this feature. (Mark Stosberg)
	- Bumped required Perl version to 5.6.1 in Makefile.PL. We were already
		already requiring 5.6.1 for Pg.pm since 1.31.
	- Removed extra "return" statement in quote.c to make Solaris happy
		(CPAN bug #4419) [Rudy Lippan]
	- Changed get_info(29) to return (") instead of (\")
		(CPAN bug #4829) [Greg Sabino Mullane]

1.31 Mon Nov 17 21:21:21 UTC 2003
	- $dbh->{TYPE} now returns SQL_TYPE_TIMESTAMP instead of 1114 for
		timestamp columns. (In 1.31_x {x| x<8} $sth->{TYPE} returned 0
		but reported by ["Hirche, Joachim" <Joachim.Hirche@cimconcepts.com>]).
	- Raised required versions to Perl 5.6.1 and DBI 1.35
	- Fix syntax error related to pg_server_version (CPAN bugs #2492,2755,3121)
	- Cache multiple calls to pg_server_version.
	- Notice messages generated by the database now use the perl
		warning mechanism instead of going to stderr.
		[Dominic Mitchell <dom@semantico.com>]
	- $dbh->prepare() rewrites the SQL statement into an internal form,
		striping out comments and whitespace, and if PostgreSQL > 7.3 takes the
		stripped statement and passes that to Postgres' PREPARE statement,
		then rewrites the statement as 'EXECUTE "DBD::PG::cached_query n"
		($1, $2, ... $n, $n+1)' for DBD::Pg's execute.
		-- Currently disabled until PREPARE works a little better
	- Allows the use of :n and :foo bind params. So:
		(SELECT * FROM foo WHERE 1 = :this and 2 = :that) will now work.
	- Complains on execute when unbound bind params are submitted
		(instead of defaulting to NULL)
	- Switched over to use driver.xst.
	- pg_error() removes \n's rather than truncating the message on the first \n.
	- Fixed statement scan problem where the preparse of
		"SELECT foo[3:33] from bar" was scanning :33 as a placeholder
	- Moved the quoting of bind values out of execute() and into
		bind -- as there is no need to requote the value every time execute
		is called.
	- :veryverylongplaceholdername == Long walk, short pier -- fixed.
	- quote() is now in C and uses same code as bind_param.
	- Quoting and dequoting now use libpq quoting functions where available
		(I still need to take the libpq functions swiped out of quote.c and move
		it into libpqswip.c with license info &c., and switch ifndefs to ifdefs)
	- bind_param() will convert from 1,0 to TRUE/FALSE when pg_type
		is PGBOOLOID.
	- Fixed many heap buffer overruns.
	- Added support for the get_info() method [Greg Sabino Mullane]
	- Added tests for POD validation [Mark Stosberg]
	- Several improvements to column_info, including:
		- Fixed column_info so NULLABLE field shows correctly. [kevin@sysexperts.com]
		- REMARKS field works now [Mark Stosberg]
		- COLUMN_DEF fixed
		- COLUMN_SIZE fixed
		- pg_constraint column added to display column constraints
		- additional documentation and tests added
	- make test is now more intelligent and will bail out early if
		db connection fails. [Greg Sabino Mullane]


To generate a diff of this commit:
cvs rdiff -r1.30 -r1.31 pkgsrc/databases/p5-DBD-postgresql/Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.