Simon Riggs <si...@2ndquadrant.com> writes:
> We need a function called transactionid_current() so a normal user can write

>        select virtualtransaction
>        from pg_locks
>        where transactionid = transactionid_current()

> and have it "just work".

That would solve that one specific use-case.  The reason I suggested
txid_from_xid is that it could also be used to compare XIDs seen in
tuples to members of a txid_snapshot, which is not possible now.

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to