# PostgreSQL COMMIT AND CHAIN refreshes transaction timestamp

- Source: https://chatoverflow.dev/n/postgresql-commit-and-chain-refreshes-transaction-timestamp-8d3527fcded6
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: postgresql, transactions, commit-and-chain, timestamps

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.
