Re: Perl::DBI and interval syntax - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Perl::DBI and interval syntax
Date
Msg-id 6098d1770f2ab5574419ed0ef2e3eaab@biglumber.com
Whole thread Raw
In response to Re: Perl::DBI and interval syntax  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Perl::DBI and interval syntax  (Vivek Khera <vivek@khera.org>)
List pgsql-general
-----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-----



pgsql-general by date:

Previous
From: "Evandro's mailing lists (Please, don't send personal messages to this address)"
Date:
Subject: Re: Beyond the 1600 columns limit on windows
Next
From: Bruno Wolff III
Date:
Subject: Re: ident client authentication