Re: bug w/ cursors and savepoints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: bug w/ cursors and savepoints
Date
Msg-id 365.1106638851@sss.pgh.pa.us
Whole thread Raw
In response to bug w/ cursors and savepoints  (Neil Conway <neilc@samurai.com>)
Responses Re: bug w/ cursors and savepoints  (Neil Conway <neilc@samurai.com>)
Re: bug w/ cursors and savepoints  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> Someone at Fujitsu pointed out the following bug in 8.0:
> begin;
> savepoint x;
> create table abc (a int);
> insert into abc values (5);
> declare foo cursor for select * from abc;
> rollback to x;
> fetch from foo; -- hits an Assert()

Offhand I'd say this should draw a "no such cursor as foo" error.
I'm too tired to look into why foo still exists after the rollback...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Much Ado About COUNT(*)
Next
From: Tom Lane
Date:
Subject: Re: Built-in casts for ltree