Re: warnings about invalid "search_path" - Mailing list pgsql-general

From Albe Laurenz
Subject Re: warnings about invalid "search_path"
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208419666@exadv11.host.magwien.gv.at
Whole thread Raw
In response to warnings about invalid "search_path"  (Samba <saasira@gmail.com>)
Responses Re: warnings about invalid "search_path"
List pgsql-general
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.

Try to add %d to the log_line_prefix parameter.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Are stored procedures always kept in memory?
Next
From: Samba
Date:
Subject: Re: warnings about invalid "search_path"