Re: bug w/ cursors and savepoints

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bug w/ cursors and savepoints
Дата
Msg-id 365.1106638851@sss.pgh.pa.us
обсуждение исходный текст
Ответ на bug w/ cursors and savepoints  (Neil Conway <neilc@samurai.com>)
Ответы Re: bug w/ cursors and savepoints  (Neil Conway <neilc@samurai.com>)
Re: bug w/ cursors and savepoints  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список 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 по дате отправления:

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Much Ado About COUNT(*)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Built-in casts for ltree