Re: [GENERAL] Setting search_path ignored
От | Guyren Howe |
---|---|
Тема | Re: [GENERAL] Setting search_path ignored |
Дата | |
Msg-id | 08b4087e-b1a5-471b-9ee5-775893fb296f@Spark обсуждение исходный текст |
Ответ на | Re: [GENERAL] Setting search_path ignored ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: [GENERAL] Setting search_path ignored
Re: [GENERAL] Setting search_path ignored |
Список | pgsql-general |
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.johnston@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."Values set with ALTER DATABASE and ALTER ROLE are applied only when starting a fresh database session."David J.
В списке pgsql-general по дате отправления: