Re: UPDATE ... CURRENT OF cursorname

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE ... CURRENT OF cursorname
Date: 2008-09-01 22:36:38
Message-ID: 48BC6E76.6050402@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Richard Broersma wrote:
> On Mon, Sep 1, 2008 at 3:21 PM, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
>> Richard Broersma wrote:
>>
>>> stmt.setCursorName("x");
>> The postgresql JDBC driver does not support positioned updates (as the
>> metadata will tell you), and setCursorName() is completely ignored.
>
> Thanks!, since I am only in the learning/reading stage, I hadn't
> performed any tests. However, if the feature were to be added some
> the future, what would the attended affect be?

Well, frankly, I doubt it will be added in the future, because the
driver does not map resultset operations directly to cursor operations
on the server.

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ingmar Lötzsch 2008-09-02 15:26:03 Re: Table Alias posing problem in Update statements
Previous Message Richard Broersma 2008-09-01 22:28:21 Re: UPDATE ... CURRENT OF cursorname