-----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 g...@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-----