Horton

Re: pg_restore 14 skips ACL COLUMN when --schema is used

Kong Man <kong_mansatiansin@hotmail.com>

View thread View on postgr.es
From: Kong Man <kong_mansatiansin@hotmail.com>
To: Euler Taveira <euler@eulerto.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2023-08-02T21:05:25Z
Lists: pgsql-bugs 
> You didn't provide a test case as requested

I apologize for not having a complete test case.  It's my first reporting a bug.  I started to get the hang of it now.
________________________________
From: Euler Taveira <euler@eulerto.com>
Sent: Wednesday, August 2, 2023 4:53 PM
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kong Man <kong_mansatiansin@hotmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: pg_restore 14 skips ACL COLUMN when --schema is used

On Wed, Aug 2, 2023, at 5:06 PM, Tom Lane wrote:
Yeah, ignoring dependencies on ACLs in this logic seems like the best
way forward.  Do you want to write a patch?

I like your suggestion. Let me give it a try.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

Commits

  1. Fix omission of column-level privileges in selective pg_restore.

  2. Clean up some aspects of pg_dump/pg_restore item-selection logic.