Getting acces to MVCC version number

Поиск
Список
Период
Сортировка
От Jean-Luc Lachance
Тема Getting acces to MVCC version number
Дата
Msg-id 3D8B676D.3109ACFA@nsd.ca
обсуждение исходный текст
Ответ на Re: Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Getting acces to MVCC version number  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all developpers,

This is just a idea.

How about making available the MVCC last version number just like oid is
available.  This would simplify a lot of table design.  You know, having
to add a field "updated::timestamp" to detect when a record was updated
while viewing it (a la pgaccess).

That way, if the version number do not match, one would know that the
reccord was updated since last retrieved.

What do think?

JLL

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Monitoring a Query
Следующее
От: Elaine Lindelef
Дата:
Сообщение: Re: PHP + PostgreSQL