PostgreSQL 12.1 patch for "private_modify" table creation option fordata validation reinforcement - Mailing list pgsql-hackers

From Abdul Yadi AH-2
Subject PostgreSQL 12.1 patch for "private_modify" table creation option fordata validation reinforcement
Date
Msg-id CAJJaA=fQmEJ0jNxK+BnbbiOrdj-8rMfiFvesbZajYEJtQ0P40Q@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 12.1 patch for "private_modify" table creation option for data validation reinforcement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
As I have published on https://abdulyadi.wordpress.com/2019/12/26/reinforce-data-validation-prevent-direct-table-modification/, the patch is to have "private_modify" option in table creation. For example:
CREATE TABLE mytable (id integer) WITH (private_modify=true);

Having the option set, even superuser can not insert/update/delete the table outside SQL or SPI-based function where complex data validation takes place.

The patch has been passed all regression test provided in Postgresql source code (src/test/regression): make check, make installcheck, make installcheck-parallel, make checkworld, make install-checkworld.

Regards,
Abdul Yadi
Attachment

pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: use CLZ instruction in AllocSetFreeIndex()
Next
From: Fabien COELHO
Date:
Subject: Re: [PATCH v1] pg_ls_tmpdir to show directories