Re: Cursor with hold emits the same row more than once across commits in 8.3.7

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Cursor with hold emits the same row more than once across commits in 8.3.7
Дата
Msg-id 1244569885.21727.64.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на Re: Cursor with hold emits the same row more than once across commits in 8.3.7  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Cursor with hold emits the same row more than once across commits in 8.3.7  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-bugs
On Tue, 2009-06-09 at 12:07 -0400, Tom Lane wrote:
> We could probably fix this specific issue by refactoring things in such
> a way that the seqscan start point is frozen on the first read and
> re-used after rewinds.

I don't know what you mean by "frozen" exactly, but the start point of a
synchronized scan is stored in shared memory; otherwise, it wouldn't
know where to stop.

Regards,Jeff Davis



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Cursor with hold emits the same row more than once across commits in 8.3.7
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Cursor with hold emits the same row more than once across commits in 8.3.7