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 <[email protected]> Envoyé : Wednesday, May 20, 2020 9:28:21 PM À : Patrick FICHE <[email protected]> Cc : [email protected] <[email protected]> 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.
