Re: DELETE CASCADE

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: David Christensen <david(dot)christensen(at)crunchydata(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DELETE CASCADE
Date: 2021-06-05 07:29:14
Message-ID: 54a49b72-dba9-5087-fa92-6c471327d48d@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 04.06.21 22:24, David Christensen wrote:
> So what are the necessary and sufficient conditions to check at this
> point?  The constraint already exists, so what permissions would we need
> to check against which table(s) in order to grant this action?

I think you would need DELETE privilege on all affected tables.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2021-06-05 07:30:42 Re: DELETE CASCADE
Previous Message Amit Kapila 2021-06-05 06:42:49 Re: logical decoding bug: segfault in ReorderBufferToastReplace()