Postgres Pro
Downloads
Home   >   mailing lists

Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE - Mailing list pgsql-hackers

From Jim Mlodgenski
Subject Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Date
Msg-id CAB_5SRe6jUCoXadOE=d2iEUhv+x6E+_UnysL3oJLh_e_eUrEoA@mail.gmail.com
Whole thread Raw
In response to PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (David Fetter <david@fetter.org>)
Responses Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view


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 by date:

Previous
From: "happy times"
Date:
Subject: Unexpected memory usage for repeated inserts within plpgsql function
Next
From: Craig Ringer
Date:
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE