Re: UPDATE ... CURRENT OF cursorname - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: UPDATE ... CURRENT OF cursorname
Date
Msg-id 48BC6E76.6050402@opencloud.com
Whole thread Raw
In response to Re: UPDATE ... CURRENT OF cursorname  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-jdbc
Richard Broersma wrote:
> On Mon, Sep 1, 2008 at 3:21 PM, Oliver Jowett <oliver@opencloud.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

pgsql-jdbc by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: UPDATE ... CURRENT OF cursorname
Next
From: Ingmar Lötzsch
Date:
Subject: Re: Table Alias posing problem in Update statements