Skip site navigation (1) Skip section navigation (2)

DBD::Pg 2.0.0 released

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: DBD::Pg 2.0.0 released
Date: 2008-02-11 23:45:42
Message-ID: 0d3d9351415f17796398848d6866a33d@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-announce
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


Version 2.0.0 of DBD::Pg, the Perl DBI interface to Postgres, has
been released. Find it at your favorite CPAN mirror.
This is a major release, so aggressive testing and feedback is
much appreciated.

Please report any bugs here:

http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Pg

SHA1 and MD5 checksums:

920fa860ee79f4184201005264ab0ef8d7c0e479  DBD-Pg-2.0.0.tar.gz
71757069e05662985f2931e84edc3e6c  DBD-Pg-2.0.0.tar.gz


- From the Changes file:

Major changes:

  - Make minimum supported server 7.4. [GSM]
  - Overhaul COPY functions: deprecate pg_getline, pg_putline,
    and pg_endcopy. The new functions are pg_getcopydata,
    pg_getcopydata_async, pg_putcopydata, and pg_putcopyend. [GSM]
  - Add support for arrays: can pass in arrayrefs to execute, and
    they are automatically returned as arrays when fetching. [GSM]
  - Add support for asynchronous queries. [GSM]
  - Allow raw transaction statements through - in other words,
    do not croak if $dbh->prepare("COMMIT") is attempted. Not
    only was this a little too controlling, there is a growing
    host of other commands such as "COMMIT PREPARED" that we
    need to allow. [GSM].
  - Check transaction status after each command, to allow
    things such as 'PREPARE TRANSACTION' to work properly.
    (CPAN bug #32423) [GSM]
  - Overhauled the data type system. [GSM]
  - Switch from cvs to subversion. Switch from gborg to perl.org.
  - Change versioning system to three numbered system.

Bug fixes:

  - Add $dbh->{pg_placeholder_dollaronly} to allow '?' and other symbols
    to be used in prepared statements without getting interpreted as
    placeholders, i.e. the geometric operator '?#' (CPAN bug #24124) [GSM]
  - Fix memory leak in bytea quoting. (CPAN bug #21392). Fix memory leak
    in pg_notifies. [Stephen Marshall smarshall(at)wsi(dot)com]
  - Fix memory leak when using savepoints. (CPAN bug #29791)
    [airwave(at)cpan(dot)org]
  - Use adbin, not adsrc, when figuring out the sequence name for the
    last_insert_id() method. This allows the function to work properly
    if the sequence name is changed. Note that {pg_cache=>0} should be
    passed to the function if you expect this might happen.
    (CPAN bug #30924) [GSM]
  - Use unsigned chars when parsing passed-in queries, preventing UTF-8
    strings from ruining the prepare. UTF-16 may still cause problems.
    (CPAN bug #31577) [GSM]
  - Fix crash when executing query with two placeholders side by side.
    Thanks to Daniel Browning for spotting this. [GSM]
  - Skip item if no matching key in foreign_key_info.
    (CPAN bug #32308) [GSM]
  - Fix bug in last_insert_id. (CPAN bug #15918) [orentocy(at)gmail(dot)com]
  - Fix pg_description join in table_info(). [Max Cohan max(at)endpoint(dot)com]
  - Make sure arrays handle UTF-8 smoothly (CPAN bug #32479) [GSM]
  - Force column names to respect utf8-ness. Per report from Ch Lamprect. [GSM]
  - Make sure array items are marked as UTF as needed.
    (CPAN bug #29656) [GSM]
  - Force SQL_REAL and SQL_NUMERIC to be float8 not float4.
    (CPAN bug #30010) [GSM]
  - Allow objects with stringification overloading to work with quote().
    (CPAN bug #32868) [David E. Wheeler and GSM]
  - Use prepare_cached in last_insert_id function. (CPAN bug #24313)
  - Switch from pow to powf to support AIX compiler issue.
    (CPAN bug #24579) [GSM]

Enhancements and API changes:

  - Complain loudly and fail to proceed if Makefile.PL finds no -lpq [GSM]
  - Add three new columns to column_info, to return unquoted
    version: pg_schema, pg_table, and pg_columns. Add all
    three to primary_key_info, and the first two to table_info
    (CPAN bug #20282) [GSM]
  - Change $dbh->{User} to $dbh->{Username} [GSM]
  - Change $dbh->{Name} to return the entire DSN string, minus the
    'dbi:Pg:' part. Thanks to Mark Stosberg for the idea. [GSM]
  - Allow data_sources to accept optional arguments. [GSM]
  - Add private_attribute_info() method. [GSM]
  - Add SQL_INTERVAL and others to types.c [GSM]
  - Added statistics_info function [Brandon Black blblack(at)gmail(dot)com]
  - Be much more flexible in test connection options. [GSM]
  - Overhaul test suite, allow tests to be run individually. [GSM]

New and experimental:

  - Quick support for named trace level 'SQL' [GSM]
  - Very experimental support for bind_param_inout, use with caution. [GSM]

Documentation fixes:

  - Fix bad PG_INTEGER example in docs, thanks to Xavi Drudis Ferran.
    (CPAN bug #31545) [GSM]
  - Fix META.yml file. (CPAN bug #25759) [GSM]



- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200802111802
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFHsN4DvJuQZxSWSsgRA8QbAJ9SQW57bGGgpIMvWe6bRMUPR7b8oACggGxd
JZBT6TttYA1NdaxKmesEnV4=
=M1Rn
-----END PGP SIGNATURE-----



pgsql-announce by date

Next:From: Joshua D. DrakeDate: 2008-02-14 19:39:16
Subject: PostgreSQL Conference East: Talks announced
Previous:From: David FetterDate: 2008-02-11 05:25:32
Subject: Postgres Weekly News - February 10 2008

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group