DBD-Pg

Changes for version 1.31_7 - 2003-10-29

Raised required versions to Perl 5.6.1 and DBI 1.35
Fix syntax error related to pg_server_version (CPAN bugs #2492 and #2755)
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 for 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() only removes \n's don't truncate message on 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. Sort 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 failes. [Greg Sabino Mullane]