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

M Sarwar <sarwarmd02@xxxxxxxxxxx> · Sun, 9 Jun 2024 16:41:17 +0000

Hi Matthew,

Thanks for taking a look on this issue.

I am feeling the same way like Ron that it would be handy if this can be made available thru the database itself.

You may take the feedback with few other experienced DBAs ( I know that this group has lot of experienced members )  on this.

Thanks,

Sarwar

From: Wetmore, Matthew (CTR) <Matthew.Wetmore@xxxxxxxxxxxxx>

Sent: Friday, June 7, 2024 1:29 PM

To: Ron Johnson <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>

Subject: RE: [EXTERNAL] Re: How to find the view modified date and time and user name

Why do you expect the database to do something globally.  This is an open source platform with vastly different use cases.

If you need detailed stats on changes, you can build _history tables that track this.

Google will get you there.

From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>

Sent: Thursday, June 6, 2024 6:40 PM

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx

Subject: [EXTERNAL] Re: How to find the view modified date and time and user name

On Thu, Jun 6, 2024 at 9:14 PM Tom Lane <tgl@xxxxxxxxxxxxx>
 wrote:

Ron Johnson <ronljohnsonjr@xxxxxxxxx>
 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?

1. That's not terribly helpful if it was altered three weeks ago, but you only keep two weeks of log files.
2. "I'm telling you, PHB, that table hasn't been modified in the past two years.  See?  Says so right here in the database."
3. "What happened to the index that's needed for the monthly reports?"

Bottom line: sometimes, "everyone else does it" for very good and important reasons that are *vital* but rare.

CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s)
 or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2024 Evernorth