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

From Hiroshi Inoue
Subject Re: updateable cursors & visibility
Date
Msg-id 000c01c2f63e$8f70e120$0e283ddb@PbgX
Whole thread Raw
In response to Re: updateable cursors & visibility  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net] 
> 
> 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.

If I recognize the standard correctly, SENSITIVE cursors don't
have to see the changes of other transactions.

regards,
Hiroshi Inoue



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: About snapshots
Next
From: Tom Lane
Date:
Subject: Re: Changing behavior of BEGIN...sleep...do something...COMMIT