Re: [GENERAL] Fun with Cursors- how to rewind a cursor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Fun with Cursors- how to rewind a cursor
Дата
Msg-id 25786.1174864084@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Fun with Cursors- how to rewind a cursor  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> I'd venture that we should try to get rid of the restriction, but I'm
> unsure whether removing the error check is sufficient or whether there
> are real problems it's preventing.

I did a little experimentation and it seems that DECLARE CURSOR,
FETCH, and CLOSE work perfectly fine when executed through SPI
(after diking out the error check).  So I see no reason to have
that prohibition in place --- we may as well just take it out and
save a few lines of code.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Idea for cleaner representation of snapshots
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tsearch2 regression test failures