On Saturday, November 11, 2023, <pf(at)pfortin(dot)com> wrote:
>
> If EXECUTE is really supposed to be required; is it a bug that I
> finally got regexp_replace() to work...?
>
The PUBLIC pseudo-role is granted permission, at the time of the function’s
creation (i.e., as a default privilege) to execute all functions in the
database. All roles inherit the grants given to PUBLIC.
David J.