From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to get Transaction Timestamp ? |
Date: | 2011-09-16 18:39:51 |
Message-ID: | CA+h6AhgBjwy39CKKKJswscdB3F7CqZx+ei0SRX+eQPUuEVuVng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Respected All,
Can we get the transaction timestamp for INSERT/UPDATE/DELETE ran against
table in the database ?
postgres=# create table trx_test(id int, name char(30));
CREATE TABLE
postgres=# insert into trx_test VALUES (1,'AAA');
INSERT 0 1
postgres=# insert into trx_test VALUES (2,'BBB');
INSERT 0 1
postgres=# insert into trx_test VALUES (3,'CCC');
INSERT 0 1
postgres=# select xmin,* from trx_test ;
xmin | id | name
---------+----+--------------------------------
1348711 | 1 | AAA
1348712 | 2 | BBB
1348713 | 3 | CCC
(3 rows)
We can get a Transaction ID, but not the transaction timestamp when it
performed.
Kindly advice me.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Vitor Reus | 2011-09-16 19:50:06 | CUDA Sorting |
Previous Message | Alec Swan | 2011-09-16 17:29:48 | Re: Log duration and statement for slow queries + limiting the number of log files generated |