Re: Perl::DBI and interval syntax

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Perl::DBI and interval syntax
Date: 2005-11-08 13:16:47
Message-ID: 6098d1770f2ab5574419ed0ef2e3eaab@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200511080815
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Claus Scherschel 2005-11-08 13:19:21 Schemas shown in ODBC
Previous Message Evandro's mailing lists (Please, don't send personal messages to this address) 2005-11-08 13:14:03 Re: Beyond the 1600 columns limit on windows