Re: warnings about invalid "search_path"

Thanks Scott,

I'll try that out; I hope this would solve my problem...

Regards,
Samba
============================================================

On Tue, Aug 7, 2012 at 8:30 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Aug 7, 2012 at 7:15 AM, Samba <saasira(at)gmail(dot)com> wrote:
> > Thanks Gabriele for those pointers,
> >
> > I could now narrow it down to two things:
> >
> > "system_data" user logging into other databases [one of those may be the
> > default 'postgres'] which does not have "system_data" schema
> > other users [like 'postgres'] logging into their own or even other
> databases
> > which does not have "system_data" schema.
> >
> > I did notice that we have added "system_data" schema to a few other users
> > [roles] who are also supposed to login to the database containing
> > "system_data" schema and that is causing this side-effect of logging
> these
> > warning messages when users who have "system_data" in the search_path log
> > into other databases that do not have "system_data" schema.
> >
> > So, what i understand is needed for me is "how to add a schema (or
> multiple
> > schemas) in the search path for a database irrespective of whichever user
> > logs in to the database?"
> >
> > Could you explain how to add "schema(s) into search_path for a database
> > irrespective of the user logging-in?
>
> You can set search path for a particular database:
>
> alter database xyz set search_path='abc','xyz';
>