Re: txid_status() off-by-one error

2019-03-27 Thread Thomas Munro
On Wed, Mar 27, 2019 at 7:55 PM Thomas Munro wrote: > If you keep asking for txid_status(txid_current() + 1) in new > transactions, you eventually hit: > > ERROR: could not access status of transaction 32768 > DETAIL: Could not read from file "pg_xact/" at offset 8192: No error: 0. > -

txid_status() off-by-one error

2019-03-26 Thread Thomas Munro
Hello hackers, postgres=> select txid_status(txid_current() + 3); ERROR: transaction ID 627 is in the future postgres=> select txid_status(txid_current() + 2); ERROR: transaction ID 627 is in the future postgres=> select txid_status(txid_current() + 1); txid_status - in progress (1