Re: How to get Transaction Timestamp ?

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get Transaction Timestamp ?
Date: 2011-09-17 14:49:48
Message-ID: CABRT9RAQU0kvfcM2R56_wKocHPnC37F72zFKYPdbK3VLR4+MaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/9/17 pasman pasmański <pasman(dot)p(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-09-17 15:16:31 Re: How to get Transaction Timestamp ?
Previous Message adebarros 2011-09-17 14:49:17 Re: Upgrading from 9.0->9.1 Ubuntu Best Practices