Re: updateable cursors & visibility

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: updateable cursors & visibility
Date: 2003-03-29 15:42:46
Message-ID: Pine.LNX.4.44.0303291259210.2289-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hiroshi Inoue writes:

> Must a SENSITIVE cursor see other applications' changes made
> while the cursor is open ?

Yes. It is immaterial whether the change came from a different
application or the same one.

Nevertheless, the cursor sensitivity does not excuse you from observing
the transaction isolation level. So even if the cursor is sensitive you
should not be able to see other transactions' changes if you are in a
serializable transaction.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Csaba 2003-03-29 16:42:17 Rules / Triggers something a little bit more chellanging
Previous Message Peter Eisentraut 2003-03-29 15:42:17 SQL/XML examples