Re: Exposing the Xact commit order to the user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Exposing the Xact commit order to the user
Дата
Msg-id 28952.1274818568@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Exposing the Xact commit order to the user  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Joseph Adams
Дата:
Сообщение: Re: Fwd: Hiding data in postgresql
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Synchronization levels in SR