Re: CVS JDBC driver will try to use server-side-prepare on

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: CVS JDBC driver will try to use server-side-prepare on
Date: 2003-08-15 15:58:42
Message-ID: Pine.LNX.4.33.0308151157220.31460-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-08-15 16:55:02 Re: CVS JDBC driver will try to use server-side-prepare on
Previous Message sarathi 2003-08-15 15:37:04 - trigger/function & java methods