Re: warnings about invalid "search_path"

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: warnings about invalid "search_path"
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C208419666@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на warnings about invalid "search_path"  (Samba <saasira@gmail.com>)
Ответы Re: warnings about invalid "search_path"  (Samba <saasira@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Are stored procedures always kept in memory?
Следующее
От: Samba
Дата:
Сообщение: Re: warnings about invalid "search_path"