Poul Kristensen wrote: > How come that repeating > SELECT txid_current(); > > makes 1 added to xid > shown by > select * from pg_last_committed_xact(); > > > repeating > > select * from pg_last_committed_xact(); > > does not add 1 for each repeat of > select * from pg_last_committed_xact(); The documentation says about txid_current(): get current transaction ID, assigning a new one if the current transaction does not have one Since the query runs in ist own transaction, each invocation will assign a new transaction ID. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
