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

From Neil Conway
Subject Re: 'prepare' is not quite schema-safe
Date
Msg-id 427627AB.1010204@samurai.com
Whole thread Raw
In response to Re: 'prepare' is not quite schema-safe  (Vlad <marchenko@gmail.com>)
Responses Re: 'prepare' is not quite schema-safe
Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe
List pgsql-general
Vlad wrote:
> ok, since there is no gurantee that server-side prepared query is
> still active, pergaps postgresql interface library provide way to
> check if a prepared before query still alive prior runing exec

I'm not sure I quite follow you -- in some future version of the backend
in which prepared queries are invalidated, this would be invisible to
the client. The client wouldn't need to explicitly check for the
"liveness" of the prepared query, they could just execute it -- if
necessary, the backend will re-plan the query before executing it.

-Neil

pgsql-general by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: scripts in Postgres
Next
From: "Sean Davis"
Date:
Subject: Re: Persistent Connections in Webserver Environment