Re: How do you detect row version changes in PostgreSQL? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How do you detect row version changes in PostgreSQL?
Date
Msg-id 1395.967557851@sss.pgh.pa.us
Whole thread Raw
In response to How do you detect row version changes in PostgreSQL?  ("Craig Manley" <bitneuker666@hotmail.com>)
List pgsql-sql
"Craig Manley" <bitneuker666@hotmail.com> writes:
> Some databases have a hidden field that contains a row version key.
> Everytime an update is performed on a row the value of the version field
> changes. Does PostgreSQL have a similar hidden field?

See xmin (and also cmin if you need to keep track of multiple changes
intra-transaction).  It might not be defined quite the way you want,
but if you're not picky about what a "version number" is, it'll do.
        regards, tom lane


pgsql-sql by date:

Previous
From: hlefebvre
Date:
Subject: Re: Re: Argument variables for select
Next
From: Tom Lane
Date:
Subject: Re: performance on insert/update