Re: How to get Transaction Timestamp ?

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: How to get Transaction Timestamp ?
Дата
Msg-id CABRT9RAQU0kvfcM2R56_wKocHPnC37F72zFKYPdbK3VLR4+MaA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to get Transaction Timestamp ?  (pasman pasmański <pasman.p@gmail.com>)
Список pgsql-general
2011/9/17 pasman pasmański <pasman.p@gmail.com>:
> Trigger may store timestamp to other table "timestamps". You join then
> xmin with xmin from this table to access timestamp.

But note that this is not reliable. Vacuum *does* change xmin during
the freeze process, as does a pg_dump&reload of data. Possibly other
cases that I didn't think of. I wouldn't use this hack in a real
application.

Regards,
Marti

В списке pgsql-general по дате отправления:

Предыдущее
От: adebarros
Дата:
Сообщение: Re: Upgrading from 9.0->9.1 Ubuntu Best Practices
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: How to get Transaction Timestamp ?