Re: How to find the view modified date and time and user name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to find the view modified date and time and user name
Date: 2024-06-07 01:14:12
Message-ID: 1167642.1717722852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ron Johnson <ronljohnsonjr(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-06-07 01:40:13 Re: How to find the view modified date and time and user name
Previous Message Ron Johnson 2024-06-07 00:47:06 Re: How to find the view modified date and time and user name