I now realize that the issue is indeed occurring when users who have "system_data" in their search_path log in to other databases that does not have that schema.
Could someone explain how to "add schema(s) into search_path for a database [not to user/role] irrespective of whichever user logging-in"?
Samba wrote: > I'm seeing some weired errors in the postgres logs after upgrading > to postgres-9.1(.3) about the schema added by default to search patch > > WARNING: invalid value for parameter "search_path": "system_data" > DETAIL: schema "system_data" does not exist > > We do have a user named "system_data" and a schema with the same name... > > Apart from these warning messages, there is not other problem about it
Maybe the warning is from a different database that does not have such a schema.
