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

Re: Check for prepared statement

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Check for prepared statement
Date: 2004-06-03 20:49:03
Message-ID: 20040603204903.GE31283@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

Responses

pgsql-hackers by date

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

pgsql-general by date

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

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