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.
