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/