From: | "Jonathan Brinkman" <jonathanbrinkman(at)yahoo(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: searchpath reverts to default after each server restart |
Date: | 2010-09-15 20:49:24 |
Message-ID: | 023801cb5517$7c3d1de0$74b759a0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)com]
Sent: Wednesday, September 15, 2010 4:40 PM
To: Jonathan Brinkman
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] searchpath reverts to default after each server
restart
On Wed, Sep 15, 2010 at 4:12 PM, Jonathan Brinkman
<jonathanbrinkman(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Arjen Nienhuis | 2010-09-15 22:18:52 | Re: Using libpq, floats and binary data |
Previous Message | Merlin Moncure | 2010-09-15 20:40:22 | Re: searchpath reverts to default after each server restart |