From: | Rod Taylor <rod(dot)taylor(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, David Fetter <david(at)fetter(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE |
Date: | 2017-02-05 01:08:30 |
Message-ID: | CAKddOFCQpnpx-bwe-oCMF5d+1rB56wfLQEjC0kamTt+KFSFAoA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Feb 2, 2017 at 11:40 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
> Pavel Stehule wrote:
>
> > Identification of unjoined tables should be very useful - but it is far
> to
> > original proposal - so it can be solved separately.
> >
> > This patch is simple - and usually we prefer more simple patches than one
> > bigger.
> >
> > Better to enhance this feature step by step.
>
> Agreed -- IMO this is a reasonable first step, except that I would
> rename the proposed extension so that it doesn't focus solely on the
> first step. I'd pick a name that suggests that various kinds of checks
> are applied to queries, so "require_where" would be only one of various
> options that can be enabled.
>
A general SQL-Critic would be a very welcome extension.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-02-05 01:33:37 | Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE |
Previous Message | Noah Misch | 2017-02-05 00:06:21 | Ignore tablespace ACLs when ignoring schema ACLs |