Re: Perl::DBI and interval syntax

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> This seems to be an example of breakage caused by DBI switching from
> "substitute params in client" to "use new protocol to substitute params
> in server" (prepare/execute).
>
> AIUI, if you disable use of the new protocol, it should work as before.

This is correct. Though generally not recommeded, you can switch it off
with the pg_server_prepare attribute like so:

$dbh->{pg_server_prepare} = 0;

This will force DBD::Pg to do the quoting itself, with the subsequent
penalty of speed and loss of auto type casting.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200511080815
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFDcKU7vJuQZxSWSsgRArwmAKDKe75V/TY4oYWLkiICN2osmJTmBwCcDXGy
p+yPZqpu0sv0Ov8hlBN0XkU=
=w+aj
-----END PGP SIGNATURE-----