Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL
Date
Msg-id 20030815231427.GA14392@opencloud.com
Whole thread Raw
In response to Re: CVS JDBC driver will try to use server-side-prepare on  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
On Fri, Aug 15, 2003 at 11:58:42AM -0400, Kris Jurka wrote:
>
>
> On Fri, 15 Aug 2003, Tom Lane wrote:
>
> > > Should we only be doing PREPARE on queries that are known to be safe (e.g.
> > > single-statement SELECTs), or is it better to try to catch the errors and
> > > abandon the prepare? (more general, but sounds a bit hairy).
> >
> > Uh, don't you have to be prepared to catch errors in PREPARE anyway?
> > What if the command is syntactically or semantically wrong?
> >
>
> I believe he's suggesting that on a prepare error you would retry without
> prepare instead of just reporting it back to the caller.

Yes, that's what I meant.

I've realised it won't work transparently, though, as if you're in a
transaction the bad PREPARE will abort it.

-O

pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: How to work with OID type?
Next
From: Paul Thomas
Date:
Subject: Re: - trigger/function & java methods