search_path update weirdness

Поиск
Список
Период
Сортировка
От Colin S
Тема search_path update weirdness
Дата
Msg-id DUB118-W138D1B502BC175B7224CE887780@phx.gbl
обсуждение исходный текст
Ответы Re: search_path update weirdness
Список pgsql-admin
Дерево обсуждения
Hello,

I made a bad update to search_path, which basically had line returns:

prod_candidate=# alter user postgres set search_path to 'search_path=public, schem
prod_candidate'# a1, schema2, schema3'
prod_candidate-# ;
ALTER ROLE


And now, I can't get it to insert correctly again, there always seems to be some backslashes stuck in there:


prod_candidate=# alter user postgres set search_path to '';
ALTER ROLE
prod_candidate=# select usename, useconfig from pg_user;
    usename     |                 useconfig                  
----------------+--------------------------------------------
 postgres       | {"search_path=\"\""}
 user2 | {"search_path=public, schema1, schema2, schema3"}
 user3       | {"search_path=public, schema1, schema2, schema3"}
(3 rows)

prod_candidate=# alter user postgres set search_path to 'operator, gameplay, common';
ALTER ROLE
prod_candidate=# select usename, useconfig from pg_user;
    usename     |                   useconfig                    
----------------+------------------------------------------------
 postgres       | {"search_path=\"public, schema1, schema2, schema3\""}
 user2 | {"search_path=public, schema1, schema2, schema3"}
 user3       | {"search_path=public, schema1, schema2, schema3"}
(3 rows)

Regards,

Colin

В списке pgsql-admin по дате отправления: