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