Getting acces to MVCC version number - Mailing list pgsql-general

From Jean-Luc Lachance
Subject Getting acces to MVCC version number
Date
Msg-id 3D8B676D.3109ACFA@nsd.ca
Whole thread Raw
In response to Re: Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Getting acces to MVCC version number  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Monitoring a Query
Next
From: Elaine Lindelef
Date:
Subject: Re: PHP + PostgreSQL