Marko Kreen wroted:
By the way, Can I think that the value of system column "ctid" of an
record is the logical "current version" of that record, and used to
compare with txid returned by "FUNCTIONS-TXID-SNAPSHOT"?
No, it is just physical location of the row.
Thanks, I just done some simple tested,
//////////////////////////////////////////////////////////////////////////
// initialize
//////////////////////////////////////////////////////////////////////
create table test (last_update_tx_id);
insert into test(txid_current());
/////////////////////////////////////////////////////////////////////
// Every time I do an update, I found the last_update_tx_id is equal to
the xmin
////////////////////////
begin
update test set last_update_tx_id = txid_current();
commit;
select *, test.xmin from test;
//////////////////////////////////////////////////////////////////////////
So, it seems the system column "cmin" is the logical "current version"
of that record, isn't it?
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster