Re: Prepared statements question

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
>