Perrin Harkins wrote:
On Sat, 2006-08-05 at 09:02 -0500, Mark Stosberg wrote:
However, when deploying it on mod_perl on a busy website, I quickly saw
a lot of this kind of error:
prepared statement "dbdpg_7" already exists
Do you use prepare_cached? You might want to try that, with a 3 for the
$if_active parameter.
I do, but not everywhere. However, I have now set
"pg_server_prepare => 0" immediately after connecting to prevent the
errors I was seeing. So are you suggesting I should use:
$dbh->prepare_cached($sql, { pg_server_prepare => 1 }, 3)
...throughout the web-app?
Mark
--
http://mark.stosberg.com/