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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Date: 2017-02-02 15:34:43
Message-ID: 20170202153443.GA6187@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 2, 2017 at 07:18:45AM -0800, David Fetter wrote:
> On Thu, Feb 02, 2017 at 03:16:29PM +0000, Bruce Momjian wrote:
> > I just don't see this patch going in. I think it needs are larger
> > approach to the problems it is trying to solve. I think it then
> > will be very useful.
>
> What problems that it's trying to solve are not addressed?

Unjoined tables. Inconsistent alias references. I think there are a
bunch of things and if we can make a list and get a mode to warn about
all of them, it would be very useful.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Konstantin Knizhnik 2017-02-02 15:40:18 Re: Deadlock in XLogInsert at AIX
Previous Message Magnus Hagander 2017-02-02 15:34:30 Some patch triage from Brussels