Re: V3 protocol + DECLARE problems

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: V3 protocol + DECLARE problems
Date: 2004-07-21 21:07:34
Message-ID: Pine.BSO.4.56.0407211601060.9870@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Wed, 21 Jul 2004, Oliver Jowett wrote:

> It's going to be fun using anything more than very basic cursors via the
> V3 protocol in the JDBC driver. DECLARE does not work with parameters
> passed via a Parse/Bind combination -- which is how we currently always
> pass parameters when talking V3. I'm reluctant to have two
> implementations of the parameter logic for V3 (one that does direct
> substitution, one that uses Bind) since that's extra unnecessary code
> and a recipe for inconsistent behaviour.

I see where you are going in the WITH HOLD case, I don't see how this
extends to scrollable cursors without other major changes as the Execute
protocol message assumes forward only operation.

Kris Jurka

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Jowett 2004-07-21 21:20:55 Re: V3 protocol + DECLARE problems
Previous Message Oliver Jowett 2004-07-21 21:03:44 Re: parameter hints to the optimizer

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-07-21 21:07:45 Re: patch: ensure testdbencoding test table is dropped
Previous Message Blaine Simpson 2004-07-21 20:54:02 Re: SSL URL