I logged out and back and did SET ROLE and got the same resullt.
On Oct 2, 2017, 10:06 -0400, David G. Johnston <david.g.johns...@gmail.com>, wrote: > On Mon, Oct 2, 2017 at 7:00 AM, Guyren Howe <guy...@gmail.com> wrote: > > > CREATE ROLE thing_accessor; > > > CREATE ROLE > > > CREATE SCHEMA thing_accessor; > > > CREATE SCHEMA > > > covermything=> ALTER ROLE thing_accessor SET search_path=thing_accessor; > > > ALTER ROLE > > > covermything=# SET ROLE thing_accessor; > > > SET > > > covermything=> SHOW search_path; > > > search_path > > > ----------------- > > > "$user", public > > > (1 row) > > > > > > This seems to contradict all the advice I can find about setting the > > > schema search path. > > Settings associated with roles only take affect at session start/login. > SET ROLE does not cause them to be read/executed. > > https://www.postgresql.org/docs/9.6/static/config-setting.html > > "Values set with ALTER DATABASE and ALTER ROLE are applied only when starting > a fresh database session." > > David J. > >
