Re: searchpath reverts to default after each server restart
От | Jonathan Brinkman |
---|---|
Тема | Re: searchpath reverts to default after each server restart |
Дата | |
Msg-id | 023801cb5517$7c3d1de0$74b759a0$@com обсуждение исходный текст |
Ответ на | Re: searchpath reverts to default after each server restart (Merlin Moncure <mmoncure@gmail.com>) |
Список | pgsql-general |
alter database "MYDATABASE" SET search_path TO custom, clientdata, configs, replication, structure, archive; that seems to fix it. Thank you! -----Original Message----- From: Merlin Moncure [mailto:mmoncure@gmail.com] Sent: Wednesday, September 15, 2010 4:40 PM To: Jonathan Brinkman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] searchpath reverts to default after each server restart On Wed, Sep 15, 2010 at 4:12 PM, Jonathan Brinkman <jonathanbrinkman@yahoo.com> wrote: > When i run the command > SET search_path TO custom,idsystems, clientdata, configs, replication, > structure, archive; > then when I run > SHOW search_path; > it does show those schemas as the search_path. however when i restart the > postgresql service, the search_path has reverted to $User, public. > when i put the SET search_path function in the postgresql.conf file (as > below) the service wouldn't restart. i think because it doesn't like the > "public" schema (which i don't use). > > > #[postgresql.conf file:] > # the postgresql service wouldn't start with this setting. > > > # CLIENT CONNECTION DEFAULTS > #--------------------------------------------------------------------------- > --- > > # - Statement Behavior - > > search_path = > custom,idsystems,clientdata,configs,replication,structure,archive,public; the path needs to be single quoted. merlin
В списке pgsql-general по дате отправления: