Re: SENSITIVE resultset

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Stefano B(dot) <stefano(dot)bonnin(at)comai(dot)to>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: SENSITIVE resultset
Date: 2006-10-09 14:17:37
Message-ID: 4E5A3A28-DC3E-4020-8F73-5D2BB258451F@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Stefano,

This is pretty orthogonal to the postgresql MVCC model. Postgresql
cursors are not CONCUR_UPDATEABLE by their nature. The driver would
have to do quite a bit of work to make this happen for you
transparently.

Dave
On 9-Oct-06, at 4:53 AM, Stefano B. wrote:

> Hi,
>
> I'm trying to use TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE cursors but
> it seems that I can't see the result set changes made by others.
>
> Is it possible use sensitive cursor with the JDBC postgresql driver?
>
> thanks in advance.
> Stefano
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2006-10-09 17:34:30 Re: XA transactions and autocommit
Previous Message Ludovic Orban 2006-10-09 11:51:46 Re: Postgres XA support