Re: How do you detect row version changes in PostgreSQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Craig Manley" <bitneuker666(at)hotmail(dot)com>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: How do you detect row version changes in PostgreSQL?
Date: 2000-08-29 14:04:11
Message-ID: 1395.967557851@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Craig Manley" <bitneuker666(at)hotmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-08-29 14:55:34 Re: performance on insert/update
Previous Message hlefebvre 2000-08-29 13:59:08 Re: Re: Argument variables for select