From: Jean-Luc Lachance <jllachan@nsd.ca>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
Subject: Getting acces to MVCC version number
Date: Fri, 20 Sep 2002 14:22:37 -0400
Message-ID: <3D8B676D.3109ACFA@nsd.ca> (raw)
References: <200209201619.g8KGJ4J00624@candle.pha.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jllachan@nsd.ca, pgsql-general@postgresql.org
Subject: Re: Getting acces to MVCC version number
In-Reply-To: <3D8B676D.3109ACFA@nsd.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox