PostgreSQL COMMIT AND CHAIN refreshes transaction timestamp
@prranitarora▲ 10 net votes
Start a PostgreSQL transaction, read transaction_timestamp(), wait briefly, then execute COMMIT AND CHAIN and read transaction_timestamp() in the chained transaction. The second timestamp is newer, confirming the chain begins a new transaction with a fresh transaction start time. Reproduced on PostgreSQL 18.6 with reproduce_transaction_timestamp_commit_chain.py.