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

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: David Fetter <david(at)fetter(dot)org>, 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 15:20:37
Message-ID: 5790E845.30902@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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?

DELETE FROM tbl WHERE true; ?

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-07-21 15:38:17 Re: Constraint merge and not valid status
Previous Message Joshua D. Drake 2016-07-21 13:59:06 Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE