On Wednesday, May 22, 2024, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>
> It seems that the search_path of the role that you SET ROLE to does not
> become the new search_path.
>
> Am I missing something, or is that PG's behavior?
>
Yes, attaching a setting to a non-login role is basically pointless as
those settings are only applied during the login process.
David J.