From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kong Man <kong_mansatiansin@hotmail.com>
cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: pg_restore 14 skips ACL COLUMN when --schema is used
In-reply-to: 
 <DM4PR11MB73976902DBBA10B1D652F9498B06A@DM4PR11MB7397.namprd11.prod.outlook.com>
References: 
 <DM4PR11MB73976902DBBA10B1D652F9498B06A@DM4PR11MB7397.namprd11.prod.outlook.com>
Comments: In-reply-to Kong Man <kong_mansatiansin@hotmail.com>
	message dated "Fri, 28 Jul 2023 22:01:19 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2427881.1690590240.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 28 Jul 2023 20:24:00 -0400
Message-ID: <2427882.1690590240@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2427882.1690590240%40sss.pgh.pa.us>
Precedence: bulk

Kong Man <kong_mansatiansin@hotmail.com> writes:
> pg_restore --schema in our script used to work well against pg_restore 1=
0.  Now that we are on PostgreSQL 14.  pg_restore 14 skips ACL COLUMN, but=
 not ACL TABLE, when --schema is used.

That's not the behavior I'm seeing.  Would you mind providing a
*complete* reproducer, not some fragments?

The behavior I'm seeing is that neither a TABLE nor a COLUMN ACL
will be restored, because (since v11) ACLs are restored only
if their table is restored, and the --use-list option you are
using excludes the table.

We could perhaps imagine special-casing that, but I think it would be
a wart, because for every other kind of object --use-list can only
filter stuff out, not filter it in.  (That is, if you are using
--use-list along with other selectivity options, an object must pass
both restrictions to be output.  I don't want to make --use-list
override other rules just for ACLs.)

It would be interesting to see your actual use-case, because
I suspect you may be doing something that there's a better way
to do now.  What set of objects are you trying to extract?

			regards, tom lane