pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to check history of sequences and constraints (version 9.1)
2+ messages / 2 participants
[nested] [flat]
* How to check history of sequences and constraints (version 9.1)
@ 2012-11-21 07:02 Shams Khan <shams.khan22@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Shams Khan @ 2012-11-21 07:02 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to check history of sequences and constraints (version 9.1)
@ 2012-11-21 14:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: Shams Khan <shams.khan22@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2012-11-21 14:37 UTC (permalink / raw)
To: Shams Khan <shams.khan22@gmail.com>; +Cc: pgsql-admin
Shams Khan <shams.khan22@gmail.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-11-21 14:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-21 07:02 How to check history of sequences and constraints (version 9.1) Shams Khan <shams.khan22@gmail.com>
2012-11-21 14:37 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox