Re: PG 18 release notes draft committed

On Wed, Jun 4, 2025 at 06:37:57PM -0400, Tom Lane wrote:
> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > Is this covering the case of executing at the end of an outer SQL command
> > (thus not deferred) that contains volatile DML functions that temporarily
> > change current_user within the function?
>
> Not quite. I think that a non-deferred AFTER trigger would ordinarily
> run as the same user that was active when we queued the event, earlier
> in the same statement --- but it's possible that some function that
> runs in between would change the active role in a non-temporary way.
> Doing that will now have different effects than it did before.

Yes, I wonder if we need to work that angle into the description.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.