Re: Prepared statements question - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: Prepared statements question
Date
Msg-id 20030113031241.GF20180@filer
Whole thread Raw
In response to Re: Prepared statements question  (Neil Conway <neilc@samurai.com>)
Responses Re: Prepared statements question  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: MOVE LAST: why?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Prepared statements question