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.rao@xxxxxxxxxxxxxxxx>: > 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@xxxxxxxxx> wrote: > >> On Fri, Sep 16, 2011 at 21:39, Raghavendra >> <raghavendra.rao@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
