Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong security context for deferred triggers? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Wrong security context for deferred triggers?
Date
Msg-id CAFj8pRDcy2OaPS7OtceFRhTRq6VKWbdnuawgaX3EXMQVwTR4VA@mail.gmail.com
Whole thread Raw
In response to Wrong security context for deferred triggers?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Wrong security context for deferred triggers?
List pgsql-hackers
Tree view


so 19. 10. 2024 v 13:02 odesílatel Laurenz Albe <laurenz.albe@cybertec.at> napsal:
On Sat, 2024-10-19 at 06:17 +0200, Pavel Stehule wrote:
> Maybe we should document so the trigger is executed with the identity used by DML command always,
> when the trigger function has no SECURITY DEFINER flag?

Good idea.  Version 3 has documentation.

perfect

all tests passed 

I'll mark this patch as ready for committer

Regards

Pavel
 

Yours,
Laurenz Albe

pgsql-hackers by date:

Previous
From: Junwang Zhao
Date:
Subject: Re: Using read_stream in index vacuum
Next
From: "David G. Johnston"
Date:
Subject: Improve documentation regarding custom settings, placeholders, and the administrative functions