cursors in LLL

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: cursors in LLL
Date: 1998-10-05 10:29:10
Message-ID: 002501bdf04a$fd6765e0$2801007e@cadzone.tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all.
I'm looking forward to the appearance of LLL in PostgreSQL 6.5 and have a
question about the sensitivity of cursors in LLL.

In LLL cursors are INSENSITIVE as Oracle ?

Currently cursors are indeterminate and in some cases they are strangely
sensitive(for me).
In LLL the behavior of cursors will be more complicated, if changes by other
transactions can be seen by fetch statements(especially for read committed
isolation level).

I hope INSENSITIVE cursors to be implemented whose behavior we can predict
and I think that they can be realized according to proposals for LLL by
Vadim.

In LLL access methods return snapshot of data as they were in _some_ point
in time.
For read committed mode this moment is the time when statement began.
For serializable mode this is the time when current transaction began.

For a INSENSITIVE cursor this is the time when it was opened(declared),
not the time when the fetch statements for it began ?

Thanks.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Terry Mackintosh 1998-10-05 13:46:18 Re: [HACKERS] Dumping of views -- done!
Previous Message Jan Wieck 1998-10-05 08:35:27 Re: [HACKERS] Dumping of views -- done!