Re: debugging: prepared statement "dbdpg_7" already exists

On May 4, 2006, at 08:56, Mark Stosberg wrote:

>  prepared statement "dbdpg_7" already exists
>
> Could this be because there DBD::Pg is on two different machines,
> talking to the same database, and each has different concept of
> what should be stored in 'dbdpg_7' ?

They *should* be connection-based.

> Using a hash of the query itself would be a useful key, because that
> means it could originate on one of the front end web servers,
> and then be re-used by one of the other ones.

That has nothing to do with the name selected for the prepared query.  
But FWIW, DBI does this by default.

Best,

David