Re: DELETE CASCADE - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: DELETE CASCADE
Date
Msg-id CAKFQuwZv7nzHg9gXbFB-KN2CcbxcYfsD05qVS_d6qA-63n7CUQ@mail.gmail.com
Whole thread Raw
In response to Re: DELETE CASCADE  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
On Thu, Jun 3, 2021 at 3:29 PM Isaac Morland <isaac.morland@gmail.com> wrote:
Surely you mean if we don't have DELETE permission on the referencing table? I don't see why we need to be a member of the table owner role.

I would reverse the question - why does this feature need to allow the more broad DELETE permission instead of just limiting it to the table owner? The latter matches the required permission for the existing cascade feature that this is extending.

David J.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance degradation of REFRESH MATERIALIZED VIEW
Next
From: Michael Paquier
Date:
Subject: Re: Move pg_attribute.attcompression to earlier in struct for reduced size?