Search Postgresql Archives

Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario

Subject: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Tue, 23 Aug 2022 17:21:29 -0700
Cc: Karsten Hilbert <Karsten.Hilbert@xxxxxxx>, pgsql-general list <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <BE1F5B0B-EBA1-4A9E-9B61-762E3397EF4E@yugabyte.com>
References: <6EA46B7D-7775-4524-96EC-E32599AA46EC@yugabyte.com> <CAKFQuwZsOpj7eQM=W2FpGo3LeoBaRv7o5GuMBDbTY94t9s2vdA@mail.gmail.com> <615A1F2A-EB13-43D8-A97C-6344DD9C892F@yugabyte.com> <trinity-41237384-5ec3-4343-8b77-937db0da5571-1660205456685@3c-app-gmx-bs36> <98604D47-FBA4-41FF-93D0-96167F1EC14D@yugabyte.com> <CAKFQuwbhCtgoc6k+Uvh84JswvNwiL6jMSVbAZ0Hj2izXgwdFoQ@mail.gmail.com> <DE13A8A9-9576-4BDF-976C-8C1A53F3B07C@yugabyte.com> <BE1F5B0B-EBA1-4A9E-9B61-762E3397EF4E@yugabyte.com>

On Tue, Aug 23, 2022 at 5:12 PM Bryn Llewellyn <bryn@xxxxxxxxxxxx> wrote:

What do you all think?

That bug reports should be sent to the -bugs mailing list with a succinct test case demonstrating the bug.

David J.

Follow-Ups:
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn

References:
- Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: David G. Johnston
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn
- Aw: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Karsten Hilbert
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: David G. Johnston
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn
- Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
  - From: Bryn Llewellyn