Horton

Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joe Conway <mail@joeconway.com>
Cc: Christophe Pettus <xof@thebuild.com>, Basha <Basha@maxcontact.com>, PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Date: 2024-09-07T15:28:54Z
Lists: pgsql-bugs 
Joe Conway <mail@joeconway.com> writes:
> I think Tom's suggestion regarding RLS on system catalogs was one 
> approach bandied about in the past, but unless I am mistaken we never 
> committed the patch to allow RLS on system catalogs (or did I miss that?)

I experimented before proposing that, and we will let you create
RLS policies on system catalogs (if allow_system_table_mods = on).
Of course the system itself will ignore those, but I don't see
why they would not work for user-issued queries.

			regards, tom lane