Horton
Menu

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

Jim Nasby <jim.nasby@bluetreble.com>

View thread
From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: David Fetter <david@fetter.org>, Michael Paquier <michael.paquier@gmail.com>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2017-01-09T00:50:12Z
Lists: pgsql-hackers 
On 1/5/17 12:04 AM, David Fetter wrote:
> +					 errmsg("UPDATE requires a WHERE clause when require_where.delete is set to on"),

ISTM that message is no longer true.

The second if could also be an else if too.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)