Cursors out of a transaction

From: David Prieto Carrellan <davidp(at)arrakis(dot)es>
To: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Cursors out of a transaction
Date: 1998-08-24 16:38:29
Message-ID: 35E19705.31848183@arrakis.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hi.

Why can't I use a cursor out of a transaction block? I really need to
do it, since I'm working with a great amount of data, and can't do
simply a 'select' and get all the results. And this is an interactive
process, which may be interrupted at any time, and I want all the
changes to be kept.

--
Greetings.
David Prieto.
mailto:davidp(at)arrakis(dot)es

Responses

  • revoke!!! at 1998-12-03 19:08:49 from Javier E Polo

Browse pgsql-general by date

  From Date Subject
Next Message Florian Wunderlich 1998-08-24 17:17:23 Re: [GENERAL] DELETE statement KILL backend <AGAIN>
Previous Message G.Elangovan 1998-08-24 16:23:50 Maximum field in a table

Browse pgsql-sql by date

  From Date Subject
Next Message Eric McKeown 1998-08-24 23:33:53 parts of date_part()
Previous Message G.Elangovan 1998-08-24 16:23:50 Maximum field in a table