Re: [GENERAL] Comparing txid_current() to xmin

2012-11-06 Thread Mike Lewis
> > Uh, txid_current returns a 64 bit value, whereas xmin only stores the 32 > least significant bits. They would certainly differ after a xid > wraparound. > > -- > Álvaro Herrerahttp://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services > Ah yes...

[GENERAL] Comparing txid_current() to xmin

2012-11-06 Thread Mike Lewis
I am trying to make a trigger that updates a row once and only once per transaction (even if this trigger gets fired multiple times). The general idea is that for a user we have a version number. When we modify the user's data, the version number is incremented then set on the object. We only ne