Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe - Mailing list pgsql-general

From David Wheeler
Subject Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe
Date
Msg-id 6BE16F6D-1F0C-4BB2-95F4-B15902E40E4E@kineticode.com
Whole thread Raw
In response to Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-general
On May 2, 2005, at 06:40 , Andrew Dunstan wrote:

> I am not sure this is reasonably fixable. Invalidating the cache is
> not a pleasant solution - the query might not be affected by the
> change in search path at all. I'd be inclined to say that this is
> just a limitation of prepare_cached() which should be documented.

I expect that Tim would happily accept a documentation patch.

   http://svn.perl.org/modules/dbi/trunk/DBI.pm

I expect that the same issue comes up for other databases, too.

Regards,

David

pgsql-general by date:

Previous
From: Dianne Chen
Date:
Subject: 7.3.9 Install Question - init.d/postgresql error?
Next
From: Marco Colombo
Date:
Subject: Re: Persistent Connections in Webserver Environment