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)

In response to

• Re: Check for prepared statement at 2004-02-18 01:40:00 from Greg Sabino Mullane

Responses

• Re: Check for prepared statement at 2004-06-06 22:57:42 from Greg Sabino Mullane

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2004-06-03 21:08:42
	Subject: Re: Nested transactions and tuple header info
Previous:	From: Alvaro Herrera	Date: 2004-06-03 20:21:06
	Subject: Re: Nested transactions and tuple header info

pgsql-general by date

Next:	From: elein	Date: 2004-06-03 20:52:37
	Subject: Re: Ingres & PostgreSQL
Previous:	From: Mike Nolan	Date: 2004-06-03 19:59:40
	Subject: Re: Creating a session variable in Postgres