Postgres Pro
Downloads
Home   >   mailing lists

Re: search_path and SET ROLE - Mailing list pgsql-general

From David G. Johnston
Subject Re: search_path and SET ROLE
Date
Msg-id CAKFQuwb=HA4=4+DRXYHXNMZiknH_9p6Fp9upSkfw+q1qX_HY1w@mail.gmail.com
Whole thread Raw
In response to search_path and SET ROLE  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: search_path and SET ROLE
Next
From: Adrian Klaver
Date:
Subject: Re: search_path and SET ROLE