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<raghavendra.rao@enterprisedb.com> wrote:> We can get a Transaction ID, but not the transaction timestamp when itShort answer: You can't. Instead, add a new "timestamptz default
> performed.
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 по дате отправления: