Re: cursors outside transactions

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: cursors outside transactions
Дата
Msg-id 3E769987.DA48CF5F@tpf.co.jp
обсуждение исходный текст
Ответ на cursors outside transactions  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> 
> On Mon, Mar 17, 2003 at 09:48:34PM -0500, Neil Conway wrote:
> 
> > (2) Use MVCC to ensure that the snapshot of the database that the
> > transaction had is still valid, even after the transaction itself has
> > committed.
> 
> What about opening a pseudo-transaction that exists only to serve the
> cursor?  That frees you from modifying VACUUM and resource management.

The simplest way to achieve it is to invoke another
session internally. Even some clients use the trick.
However, I'm little excited about it.

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/


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

Предыдущее
От: R Blake
Дата:
Сообщение: anyone? CREATELANG in pgsql 7.3.2 failing
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Nested transactions