OK, how about a backend function called 'is_prepared(name)'? Chris
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]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 [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]