Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: warnings about invalid "search_path"
Date
Msg-id 16756.1344349153@sss.pgh.pa.us
Whole thread Raw
In response to warnings about invalid "search_path"  (Samba <saasira@gmail.com>)
List pgsql-general
Tree view 
Samba <saasira@gmail.com> writes:
> 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
> ...
> Could anyone suggest what could be wrong with my setup and how to get past
> it?

From the 9.1.4 release notes:

    * Ignore missing schemas during non-interactive assignments of search_path (Tom Lane)

    This re-aligns 9.1's behavior with that of older branches. Previously
    9.1 would throw an error for nonexistent schemas mentioned in
    search_path settings obtained from places such as ALTER DATABASE SET.

            regards, tom lane

pgsql-general by date:

Previous
From: Roman Golis
Date:
Subject: Are stored procedures always kept in memory?
Next
From: Pavel Stehule
Date:
Subject: Re: Are stored procedures always kept in memory?