DBD::Pg 3.5.0 released (driver for Postgres)

[Greg Sabino Mullane]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


Version 3.5.0 of DBD::Pg, DBI driver for PostgreSQL, is
now available. This release contains two major changes:
an improved ping() method, and support for the new
backslash-escape for placeholders.

The ping() method now tries much harder to detect if the
backend is still there. Previously, there was a chance of
returning false positives, especially if inside of an open
transaction.

DBD::Pg now supports The use of a backslash character before a
placeholder - this will prevent the character after the backslash
from being treated as a placeholder.The most important and immediate
use for this is in escaping question marks, which are used in
Postgres as JSON operators (among other things). To use, just put
the backslash before a question mark, and DBD::Pg will strip the
backslash and send the question mark directly to the backend. Make
sure you use two backslashes if inside a quoted string of course.

Version 3.5.0 of DBD::Pg can be downloaded here:

http://search.cpan.org/dist/DBD-Pg/

Checksums:

16cea4efcd1f8917679920be50e23da9 DBD-Pg-3.5.0.tar.gz
5c784db28c12f9b7f9b7e9f34623c663342d0e57 DBD-Pg-3.5.0.tar.gz

Complete list of changes:

Version 3.5.0 Released January 6, 2015 (git commit bb13d3306fd1c73fac1c0c8a330c14e6b8443942)

- Allow "placeholder escaping" by the use of a backslash directly before it, e.g.
"SELECT 1 FROM jsontable WHERE foo \\? ?"
will contain a single placeholder, and the first question mark will be sent directly
to the backend to be parsed as an operator.
[Greg Sabino Mullane, Tim Bunce]
(CPAN bug #101030)

- Improve the workings of the ping() method, so it always tests for
a valid database backend and returns the correct true/false.
[Greg Sabino Mullane, with help from Andrew Gierth and Tim Bunce]
(CPAN bug #100648)

- Add get_info(9000) => 1 to indicate driver can escape placeholders.
[Tim Bunce]

- In tests, force the client_encoding to UTF8, skip tests that involve
characters not supported by the server_encoding
[Dagfinn Ilmari Mannsåker <ilm...@ilmari.org>]

- Fix memory leak when selecting from arrays
[Dagfinn Ilmari Mannsåker, reported by Krystian Samp]

- Make get_info much more efficient and slightly simpler.
[Tim Bunce]

- --
Greg Sabino Mullane gr...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201501071032
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlStUfwACgkQvJuQZxSWSsgF1gCdGBZay32O2cU9hsF2BYF86+r/
Py8AoObBv0+nSGTwgvo1obt8bg3V3Aze
=wklb
-----END PGP SIGNATURE-----