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.
