On Thu, Jul 21, 2016 at 10:27 AM, David Fetter <da...@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? >
The use case for this functionality that comes to mind is to avoid deleting/updating all the data, if user has accidentally missed the WHERE clause. Do you have other use case for this functionality? With this functionality, if user needs to actually delete or update all the rows, then he has to artificially add where clause which seems slightly inconvenient, but may be such cases are less. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
