Re: updateable cursors & visibility

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