Re: updateable cursors & visibility - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: updateable cursors & visibility
Date
Msg-id Pine.LNX.4.44.0303291259210.2289-100000@peter.localdomain
Whole thread Raw
In response to Re: updateable cursors & visibility  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: updateable cursors & visibility  ("Hiroshi Inoue" <inoue@tpf.co.jp>)
Re: updateable cursors & visibility  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: SQL/XML examples
Next
From: Peter Csaba
Date:
Subject: Rules / Triggers something a little bit more chellanging