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

From Kris Jurka
Subject Re: CVS JDBC driver will try to use server-side-prepare on
Date
Msg-id Pine.LNX.4.33.0308151157220.31460-100000@leary.csoft.net
Whole thread Raw
In response to Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL
List pgsql-jdbc

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.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Peter Royal
Date:
Subject: Debugging I/O errors occured while reading from backend
Next
From: ""
Date:
Subject: - trigger/function & java methods