Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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 19:50:50 -0700
Cc: Karsten Hilbert <Karsten.Hilbert@xxxxxxx>, pgsql-general list <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <16BB8A31-2E0A-4703-839B-24D0B2B93068@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> <CAKFQuwY0ASuguBJPxSqjBzO0eyX-GfJzJSr9oKHQ+bZRHuZk2w@mail.gmail.com> <16BB8A31-2E0A-4703-839B-24D0B2B93068@yugabyte.com>

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

The account of my GitHub issue includes a preliminary test that shows that there's something to investigate further. I copied it below. Please tell me if it meets your succinctness criteria. If it does, then I'll submit it to the psql-bugs list as you suggest.

Fair point, go ahead and just post to -bugs because I'm not going to be diving that deeply into this right now.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
- 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

Prev by Date: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
Next by Date: Re: recovery_command has precedence over phisical slots?
Previous by thread: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario
Next by thread: Modelling a web CMS in Postgres ... a little advice needed
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]