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
wrote:
> When i run the command
> SET search_path TO custom,idsystems, clientdata, configs, replication,
> structure, archive
On Wed, Sep 15, 2010 at 4:12 PM, Jonathan Brinkman
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
> post
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 p
