PostgreSQL 12.1 patch for "private_modify" table creation option fordata validation reinforcement

Поиск
Список
Период
Сортировка
От Abdul Yadi AH-2
Тема PostgreSQL 12.1 patch for "private_modify" table creation option fordata validation reinforcement
Дата
Msg-id CAJJaA=fQmEJ0jNxK+BnbbiOrdj-8rMfiFvesbZajYEJtQ0P40Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL 12.1 patch for "private_modify" table creation option for data validation reinforcement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: use CLZ instruction in AllocSetFreeIndex()
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: [PATCH v1] pg_ls_tmpdir to show directories