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.marl...@gmail.com>wrote: > On Tue, Aug 7, 2012 at 7:15 AM, Samba <saas...@gmail.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'; >