Re: SET ROLE and search_path

Thanks a lot
I will try it again. I probably missed something in my configuration.

Téléchargez Outlook pour iOS<https://aka.ms/o0ukef>
________________________________
De : Adam Brusselback <adambrusselback(at)gmail(dot)com>
Envoyé : Wednesday, May 20, 2020 9:28:21 PM
À : Patrick FICHE <Patrick(dot)Fiche(at)aqsacom(dot)com>
Cc : pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)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.