Re: How to check history of sequences and constraints (version 9.1)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shams Khan <shams(dot)khan22(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to check history of sequences and constraints (version 9.1)
Date: 2012-11-21 14:37:34
Message-ID: 2907.1353508654@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Shams Khan <shams(dot)khan22(at)gmail(dot)com> writes:
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2012-11-21 16:42:01 Re: Database archive solutions
Previous Message Gnanakumar 2012-11-21 09:21:51 Database archive solutions