pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow do you detect row version changes in PostgreSQL?
2+ messages / 2 participants
[nested] [flat]
* How do you detect row version changes in PostgreSQL?
@ 2000-08-29 10:46 Craig Manley <bitneuker666@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Craig Manley @ 2000-08-29 10:46 UTC (permalink / raw)
To: pgsql-sql@hub.org
Hi all,
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? If not then I guess
using a before update trigger that modifies a user defined field will
provide an alternative solution.
Greetings,
Craig Manley.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How do you detect row version changes in PostgreSQL?
@ 2000-08-29 14:04 Tom Lane <tgl@sss.pgh.pa.us>
parent: Craig Manley <bitneuker666@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-08-29 14:04 UTC (permalink / raw)
To: Craig Manley <bitneuker666@hotmail.com>; +Cc: pgsql-sql@hub.org
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-08-29 14:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-29 10:46 How do you detect row version changes in PostgreSQL? Craig Manley <bitneuker666@hotmail.com>
2000-08-29 14:04 ` Tom Lane <tgl@sss.pgh.pa.us>
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