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

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(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Friday, June 7, 2024 12:14 AM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Ron Johnson <ronljohnsonjr(at)gmail(dot)com>; 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

On Thursday, June 6, 2024, M Sarwar <sarwarmd02(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)com>> 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.