Re: Prepared statements question - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Prepared statements question
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEPJCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Prepared statements question  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-hackers
OK, how about a backend function called 'is_prepared(name)'?

Chris

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Kevin Brown
> Sent: Monday, 13 January 2003 11:13 AM
> To: PostgreSQL Hackers
> Subject: Re: [HACKERS] Prepared statements question
> 
> 
> Neil Conway wrote:
> > On Thu, 2003-01-09 at 22:48, Christopher Kings-Lynne wrote:
> > > With prepared statements being all well and good, how do I 
> know if the query
> > > has not yet been prepared in the backend?  Or is this simply 
> a situation
> > > where I can't win?
> > 
> > Try the EXECUTE; if it fails, run the PREPARE and then rerun the
> > EXECUTE.
> 
> Erm...won't the failed EXECUTE boot you out of the middle of a
> transaction?  The documentation doesn't make it clear what happens in
> that case, and I don't have 7.3.x running to check for myself...
> 
> 
> 
> -- 
> Kevin Brown                          kevin@sysexperts.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 



pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: Prepared statements question
Next
From: "Christopher Kings-Lynne"
Date:
Subject: pg_get_constraintdef