Re: [GENERAL] Setting search_path ignored
| От | David G. Johnston |
|---|---|
| Тема | Re: [GENERAL] Setting search_path ignored |
| Дата | |
| Msg-id | CAKFQuwYS6B=s9PTW97PvteZo8nof8kzWW_AdtrWyht7y=GovHA@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Setting search_path ignored (Guyren Howe <guyren@gmail.com>) |
| Ответы |
Re: [GENERAL] Setting search_path ignored
|
| Список | pgsql-general |
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 по дате отправления: