How to inherit search_path from template
От | Phui Hock |
---|---|
Тема | How to inherit search_path from template |
Дата | |
Msg-id | 668b6126-c958-4479-9fad-4426045181b0@x24g2000pro.googlegroups.com обсуждение исходный текст |
Ответы |
Re: How to inherit search_path from template
|
Список | pgsql-general |
Hi, How can I create a database template with altered search_path to be inherited by child databases? Say, I created a template named template_a with the following commands: # CREATE DATABASE template_a WITH TEMPLATE template1; # UPDATE pg_database SET datistemplate=true WHERE datname='template_a'; # \c template_a template_a=# CREATE SCHEMA test; template_a=# GRANT ALL ON SCHEMA test TO PUBLIC; template_a=# show search_path; search_path ---------------- "$user",public (1 row) template_a=# ALTER DATABASE template_a SET search_path = test,public; When I try to create a new database with the previous template, search_path is not inherited. test_a=# \dn List of schemas Name | Owner --------------------+---------- information_schema | postgres pg_catalog | postgres pg_toast | postgres pg_toast_temp_1 | postgres public | postgres test | postgres (6 rows) test_a=# CREATE DATABASE test_a WITH TEMPLATE template_a; test_a=# \c test_a psql (8.4.4) You are now connected to database "test_a". test_a=# show search_path; search_path ---------------- "$user",public (1 row) I've searched the archives for clue but of no avail. Any help or advice is greatly appreciated.
В списке pgsql-general по дате отправления: