Re: PG 18 release notes draft committed

On Wed, Jun  4, 2025 at 06:37:57PM -0400, Tom Lane wrote:
> "David G. Johnston" <david.g.johnston@gmail.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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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