Re: Check for prepared statement

On Wed, Feb 18, 2004 at 01:40:00AM -0000, Greg Sabino Mullane wrote:

> Fabrizio Mazzoni asked:
>
> > How can i find out if a prepared statement already exists..? Is there a
> > function  or a query i can execute ..??
>
> I have not seen an answer to this, and I am curious as well. Anyone?

Trying to prepare a dummy query maybe.

alvherre=# prepare foo as select 1;
PREPARE
alvherre=# prepare foo as select 2;
ERROR:  la sentencia preparada "foo" ya existe
alvherre=# execute foo;
 ?column?
----------
        1
(1 fila)

> (Cross-posting to hackers due to the lack of response on general)

Wow, you are really desperate.  Cc'ed two times!

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Es filósofo el que disfruta con los enigmas" (G. Coli)