Re: How to get Transaction Timestamp ? - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: How to get Transaction Timestamp ?
Date
Msg-id CABRT9RAQU0kvfcM2R56_wKocHPnC37F72zFKYPdbK3VLR4+MaA@mail.gmail.com
Whole thread Raw
In response to Re: How to get Transaction Timestamp ?  (pasman pasmański <pasman.p@gmail.com>)
List 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 by date:

Previous
From: adebarros
Date:
Subject: Re: Upgrading from 9.0->9.1 Ubuntu Best Practices
Next
From: Scott Ribe
Date:
Subject: Re: How to get Transaction Timestamp ?