Re: updateable cursors & visibility

From: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>
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 22:00:06
Message-ID: 000c01c2f63e$8f70e120$0e283ddb@PbgX
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e(at)gmx(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-29 22:45:18 Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Previous Message Alvaro Herrera 2003-03-29 17:04:28 About snapshots