Discussion:
How to check history of sequences and constraints (version 9.1)
(too old to reply)
Shams Khan
2012-11-21 07:02:50 UTC
Permalink
Hi Experts,

I want to check the last reset valued of sequence and the date of foreign
key constraint when it was created. Is that possible in postgres 9.1
version??
Please help me on that.
Tom Lane
2012-11-21 14:37:34 UTC
Permalink
Post by Shams Khan
I want to check the last reset valued of sequence and the date of foreign
key constraint when it was created. Is that possible in postgres 9.1
version??
No, the system doesn't track any such thing. You could possibly set
log_statement to record all commands of interest in the postmaster log
and then trawl through that data, but it wouldn't be especially easy.

regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...