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

From: Jim Mlodgenski <jimmy76(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Date: 2016-07-21 13:21:55
Message-ID: CAB_5SRe6jUCoXadOE=d2iEUhv+x6E+_UnysL3oJLh_e_eUrEoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 21, 2016 at 12:57 AM, David Fetter <david(at)fetter(dot)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.
https://github.com/uptimejp/sql_firewall

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-07-21 13:29:12 Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Previous Message happy times 2016-07-21 10:39:20 Unexpected memory usage for repeated inserts within plpgsql function