Re: How to find the view modified date and time and user name - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to find the view modified date and time and user name
Date
Msg-id 1167642.1717722852@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to find the view modified date and time and user name  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: How to find the view modified date and time and user name
Re: How to find the view modified date and time and user name
List pgsql-admin
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> What matters is that the DBA can see "ah, Bob altered table foo last
> Thursday at 14:30.  Let's check the log file to see what he did."

I'm not finding that argument terribly convincing.  If you have a
DDL log file, you can grep it to find the last change (and the
ones before that, in case it was Alice's fault not Bob's).  If
you don't have such a log file, how much does a last-changed
timestamp really help you?

            regards, tom lane



pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: How to find the view modified date and time and user name
Next
From: Ron Johnson
Date:
Subject: Re: How to find the view modified date and time and user name