Re: Postgresql 9.5 committing and log sequence number

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