Re: allow_system_table_mods stuff

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: allow_system_table_mods stuff
Date: 2019-06-28 09:51:01
Message-ID: a7455db0-2fc0-4ddc-4d8f-e4c860957a34@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here is a new patch after the discussion.

- Rename allow_system_table_mods to allow_system_table_ddl.

(This makes room for a new allow_system_table_dml, but it's not
implemented here.)

- Make allow_system_table_ddl SUSET.

- Add regression test.

- Remove the behavior that allow_system_table_mods allowed
non-superusers to do DML on catalog tables without further access checking.

I think there was general agreement on all these points.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v2-0001-New-and-improved-allow_system_table_ddl-setting.patch text/plain 43.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2019-06-28 09:54:34 Re: postgres_fdw: Minor improvement to postgresAcquireSampleRowsFunc
Previous Message Etsuro Fujita 2019-06-28 09:38:51 postgres_fdw: Minor improvement to postgresAcquireSampleRowsFunc