Getting acces to MVCC version number

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Getting acces to MVCC version number
Date: 2002-09-20 18:22:37
Message-ID: 3D8B676D.3109ACFA@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bowlby 2002-09-20 18:50:22 Adjustin Priority levels..
Previous Message Elaine Lindelef 2002-09-20 18:12:11 Re: PHP + PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-09-20 18:28:15 Re: Improving speed of copy
Previous Message Nigel J. Andrews 2002-09-20 18:17:47 Re: [GENERAL] Memory Errors...

Browse pgsql-sql by date

  From Date Subject
Next Message CoL 2002-09-20 18:42:50 Re: Two Permance Questions
Previous Message Josh Berkus 2002-09-20 16:38:38 Re: help w/ constructing a SELECT