Re: Exposing the Xact commit order to the user - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Exposing the Xact commit order to the user
Date
Msg-id 28952.1274818568@sss.pgh.pa.us
Whole thread Raw
In response to Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Exposing the Xact commit order to the user
List pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
>> No, I meant how will the *function* know, if a superuser and/or some 
>> background process can purge records at any time?

> The data contains timestamps which are supposedly taken in commit order. 

You can *not* rely on the commit timestamps to be in exact order.
(Perhaps approximate ordering is good enough for what you want here,
but just be careful to not fall into the trap of assuming that they're
exactly ordered.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Joseph Adams
Date:
Subject: Re: Fwd: Hiding data in postgresql
Next
From: Simon Riggs
Date:
Subject: Re: Synchronization levels in SR