| From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | "Florian Wunderlich" <fwunderlich(at)devbrain(dot)de> |
| Cc: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>, "Jan Wieck" <janwieck(at)yahoo(dot)com> |
| Subject: | Re: persistent portals/cursors (between transactions) |
| Date: | 2002-01-25 17:23:26 |
| Message-ID: | EKEJJICOHDIEMGPNIFIJEELHGJAA.Inoue@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: florian(at)hq(dot)factor3(dot)com [mailto:florian(at)hq(dot)factor3(dot)com]On
>
>
> Hiroshi, that's exactly what I need, though I am not sure if we are all
> really talking about the same thing.
>
> In case I misunderstood something: as far as I know, SQL92 defines that
> a cursor is by default sensitive, which means that it displays the data
> from all comitted transactions at any time. If the data changes, so does
> what the cursor returns.
AFAIK SQL92's default is indeterminate which guarantees nothing
about sensitivity. Though we don't have insensitive cursors yet
INSENSITIVE cursors are very natural for MVCC and it's not hard
to implement. In reality the current cursors see no changes after
the cursor was opened other than the ones made by the bakend
itself.
regards,
Hiroshi Inoue
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Campano, Troy | 2002-01-25 17:24:52 | Re: grant the right to select only certain rows? |
| Previous Message | Tom Lane | 2002-01-25 17:07:24 | Re: persistent portals/cursors (between transactions) |