Search Postgresql Archives

Re: Perl::DBI and interval syntax

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Nov 8, 2005, at 8:16 AM, Greg Sabino Mullane wrote:

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.

And a reduction in bugs... :-(

One I found the other day: if you set $dbh->{InactiveDestroy} it still destroys all of your prepared statements. Context is when you fork a child which needs to open its own connection, and the parent's prepared statements go away.

Need to find some tuits to file the formal bug report.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux