On Wednesday, May 22, 2024, Ron Johnson <
ronljohnsonjr@gmail.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.