Re: How to get Transaction Timestamp ?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: How to get Transaction Timestamp ?
Дата
Msg-id CA+h6AhiSLcc6WhhwXHc+WOzH9jPLk2QLGfZL3YUmcDVdj8duhg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to get Transaction Timestamp ?  (Marti Raudsepp <marti@juffo.org>)
Ответы Re: How to get Transaction Timestamp ?
Re: How to get Transaction Timestamp ?
Список pgsql-general
Дерево обсуждения
Thank you for your valuable inputs. 

Agreed, with the help of two workarounds we can pull the trx-timestamp one with additional-column/trigger and another with log_line_prefix from pg_log/logs. 

However, I was curious to know any thing stored at Page-Level(like XID) to help me in getting the transaction timestamp.

--Raghav

On Sat, Sep 17, 2011 at 7:41 AM, Marti Raudsepp <marti@juffo.org> wrote:
On Fri, Sep 16, 2011 at 21:39, Raghavendra
> We can get a Transaction ID, but not the transaction timestamp when it
> performed.

Short answer: You can't. Instead, add a new "timestamptz default
now()" column, that will get you the time of the insert.

If you want the update time, create a BEFORE UPDATE ON x FOR EACH ROW
trigger on this table to update it.

Regards,
Marti

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

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Apparent Problem With NULL in Restoring pg_dump
Следующее
От: pasman pasmański
Дата:
Сообщение: Re: How to get Transaction Timestamp ?