Re: warnings about invalid "search_path"

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Samba *EXTERN*" <saasira(at)gmail(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: warnings about invalid "search_path"
Date: 2012-08-07 14:20:52
Message-ID: D960CB61B694CF459DCFB4B0128514C208419666@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samba 2012-08-07 14:35:56 Re: warnings about invalid "search_path"
Previous Message Tom Lane 2012-08-07 14:19:13 Re: warnings about invalid "search_path"