Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick FICHE
Subject Re: SET ROLE and search_path
Date
Msg-id AM6PR05MB528776E19F5DD5B12826CB65EFB60@AM6PR05MB5287.eurprd05.prod.outlook.com
Whole thread Raw
In response to Re: SET ROLE and search_path  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-general
Tree view
Thanks a lot
I will try it again. I probably missed something in my configuration.

Téléchargez Outlook pour iOS
De : Adam Brusselback <adambrusselback@gmail.com>
Envoyé : Wednesday, May 20, 2020 9:28:21 PM
À : Patrick FICHE <Patrick.Fiche@aqsacom.com>
Cc : pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Objet : Re: SET ROLE and search_path
 
I have this exact setup, and I use roles / schema names that match so the $user var works with the search path when I set role as my application user.

> When search_path contains “$user”, does it refer to session_user or current_user ?
It uses current_user, not session_user. Works perfectly with set_role for me.

pgsql-general by date:

Previous
From: "Lu, Dan"
Date:
Subject: Question on removing primary replication node using repmgr?
Next
From: Tom Lane
Date:
Subject: Re: SET ROLE and search_path