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

From M Sarwar
Subject Re: How to find the view modified date and time and user name
Date
Msg-id DM4PR19MB5978EC6652B5C2299100438BD3C52@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: How to find the view modified date and time and user name  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
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@gmail.com>
Sent: Friday, June 7, 2024 12:14 AM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>; Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to find the view modified date and time and user name
 
On Thursday, June 6, 2024, M Sarwar <sarwarmd02@outlook.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.

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: [EXTERNAL] Re: How to find the view modified date and time and user name
Next
From: Sbob
Date:
Subject: PostgreSQL Logical replication FROM RDS TO EC2