Re: Regression tests fail once XID counter exceeds 2 billion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Regression tests fail once XID counter exceeds 2 billion
Date
Msg-id 27304.1321366679@sss.pgh.pa.us
Whole thread Raw
In response to Re: Regression tests fail once XID counter exceeds 2 billion  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Regression tests fail once XID counter exceeds 2 billion
List pgsql-hackers
Simon Riggs <simon@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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ToDo: pg_backup - using a conditional DROP
Next
From: Pavel Stehule
Date:
Subject: Re: ToDo: pg_backup - using a conditional DROP