Re: Prepared statements question

OK, how about a backend function called 'is_prepared(name)'?

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)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(at)sysexperts(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>