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 2AD2301D-17EF-4E50-9B79-2801B1169FAA@kineticode.com
Whole thread Raw
In response to Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On May 2, 2005, at 09:34 , Tom Lane wrote:

> I think you could demonstrate that if the spec is "make it look
> like the
> original query was retyped as source each time", then *every* DDL
> change
> in the database potentially requires invalidating every cached plan.
> I don't find that a desirable spec.

I agree. It seems to me that if someone is doing that sort of
chicanery, then one should not use prepared statements. IOW, I would
view it as an edge case.

Regards,

David

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.3.9 Install Question - init.d/postgresql error?
Next
From: Hannes Dorbath
Date:
Subject: Re: Persistent Connections in Webserver Environment