Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE

Поиск
Список
Период
Сортировка
От Jim Mlodgenski
Тема Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Дата
Msg-id CAB_5SRe6jUCoXadOE=d2iEUhv+x6E+_UnysL3oJLh_e_eUrEoA@mail.gmail.com
обсуждение исходный текст
Ответ на PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (David Fetter <david@fetter.org>)
Ответы Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Дерево обсуждения


On Thu, Jul 21, 2016 at 12:57 AM, David Fetter <david@fetter.org> wrote:
Folks,

Please find attached a patch which makes it possible to disallow
UPDATEs and DELETEs which lack a WHERE clause.  As this changes query
behavior, I've made the new GUCs PGC_SUSET.

What say?


Can't you implement this as a extension? The SQL Firewall project is already doing some similar concepts by catching prohibiting SQL and preventing it from executing.

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

Предыдущее
От: "happy times"
Дата:
Сообщение: Unexpected memory usage for repeated inserts within plpgsql function
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE