Re: mod_perl forking and DBD::Pg prepared statement problem

[NederHost/Sebastiaan Hoogeveen <suppressed>]

Hi,

On 31 mei 2007, at 17:38, jira wrote:

> Aaron Trevena napsal(a):
> > Hello you wonderful helpful people :)
> > I've just moved a web application (maypole/c::dbi) from one
> > development server to another, previously the code worked fine but  
> > now
> > I get :
> > 'prepared statement "dbdpg_1" does not exist' on every (prepared)
> > query to the database.
>
> I've run into that problem to. "Solved" it by setting  
> 'pg_server_prepare' to false.

The problem may be caused by slightly different syntax requirements  
for serverside prepared statements (default in PostgreSQL 8) and  
clientside 'prepared' statements (default in PostgreSQL < 8). In my  
case, I had to change every occurrence of 'interval ?' in a query  
with '?::interval' (explicit casting) to make prepared statements work.

The configuration of your response handler should not make any  
difference imho; as long as it's a PerlResponseHandler in both cases  
it will be called within virtually the same type of environment/at  
the same time. You could try to reproduce the problem in a standalone  
Perl script to make sure.

Kind regards,

--
Sebastiaan Hoogeveen <suppressed>

NederHost
http://www.nederhost.nl/