| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: cursors outside transactions |
| Date: | 2003-03-18 03:59:03 |
| Message-ID: | 3E769987.DA48CF5F@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera wrote:
>
> On Mon, Mar 17, 2003 at 09:48:34PM -0500, Neil Conway wrote:
>
> > (2) Use MVCC to ensure that the snapshot of the database that the
> > transaction had is still valid, even after the transaction itself has
> > committed.
>
> What about opening a pseudo-transaction that exists only to serve the
> cursor? That frees you from modifying VACUUM and resource management.
The simplest way to achieve it is to invoke another
session internally. Even some clients use the trick.
However, I'm little excited about it.
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-03-18 04:20:40 | Nested transactions |
| Previous Message | Keiko Kondo | 2003-03-18 03:52:52 | Re: My contract has been renewed |