Skip site navigation (1) Skip section navigation (2)

Re: Extended query: prepared statements list?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Extended query: prepared statements list?
Date: 2004-07-14 14:37:32
Message-ID: 26634.1089815852@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"M. Bastin" <marcbastin(at)mindspring(dot)com> writes:
> Is there a query on some system table that will list all names of 
> prepared statements?

No, since they are never stored on disk.  We could think of providing
some operation in the FE/BE protocol to list the available statements,
perhaps.  (In retrospect I guess it was a mistake to have the Describe
message raise a hard error for no-such-statement.  If it just sent
back a message without aborting your transaction, you could use Describe
to probe whether you'd prepared a given name yet.)

Same comments apply to Portals I suppose.

If you'd like to lobby to get this changed, pgsql-novice is not the
place; pgsql-interfaces or pgsql-hackers would be more appropriate.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: M. BastinDate: 2004-07-14 14:53:21
Subject: Re: Extended query: prepared statements list?
Previous:From: Tom LaneDate: 2004-07-14 14:29:10
Subject: Re: rule calls function, passing OLD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group