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

David Fetter <david@fetter.org>

From: David Fetter <david@fetter.org>

To: PostgreSQL Development <pgsql-hackers@postgresql.org>

Date: 2016-07-21T04:57:46Z

Lists: pgsql-hackers

Attachments

training_wheels_001.patch (text/plain) patch

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?

Thanks to Gurjeet Singh for the idea and Andrew Gierth for the tips
implementing.

Best,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate