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

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hi David,

I appreciate your response.

Sure, I will happy to share any information with Ron on this.

Thanks,

Sarwar

---

From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Sent: Friday, June 7, 2024 12:14 AM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; Ron Johnson <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to find the view modified date and time and user name

 

On Thursday, June 6, 2024, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

I do not have DDL logs. 

Then you don’t have any evidence.  But you now know what you need to work on for the future.  Until then, restore the view to what it should be and call it a lesson learned.  And double-check your role memberships, especially for roles that own objects.

Feel free to help Ron build consensus that additional metadata is desired - though you’d still have to find someone willing to write the patches.

Also, 13.5 is long out of support…

David J.