Re: How to get Transaction Timestamp ?

Trigger may store timestamp to other table "timestamps". You join then
xmin with xmin from this table to access timestamp.

2011/9/17, Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>:
> 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(at)juffo(dot)org> wrote:
>
>> On Fri, Sep 16, 2011 at 21:39, Raghavendra
>> <raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:
>> > 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
>>
>

--
------------
pasman