Hi,
I would really like to be able to externally to Postgres at some point
in time later, be able to compare the txid of 2 queries.
Namely:
The INSERT transaction for a certain row in a table, and
The SELECT transaction reading some other data.
With the one caveat that this has to work with BDR.
So ... I can easily get the current txid of the SELECT transaction by
calling txid_current().
However, - I can't in general compare it to the xmin of the table row.
BDR does ensure (it seems) that xmin is meaningfull within the local
node xid context.
But after a xid wrap-around all txids will be larger than any xmin. And
I can't get the epoch of the xmin value.
BUT ... will this work: ?
Comparing
txid_current() of the SELECT transaction,
to
txid-current()-age(xmin) of the table row?
/Peter