Re: Automated analyze process fails with custom function, which works perfect as regular user (8.4.2).

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Automated analyze process fails with custom function, which works perfect as regular user (8.4.2).
Дата
Msg-id AANLkTi=6jtw2nQL7FpFYsaNEj=KE7j1cDcgD4XWpuWAo@mail.gmail.com
обсуждение исходный текст
Ответ на Automated analyze process fails with custom function, which works perfect as regular user (8.4.2).  (Patric de Waha <lists@p-dw.com>)
Список pgsql-bugs
On Mon, Aug 9, 2010 at 3:59 AM, Patric de Waha <lists@p-dw.com> wrote:
> =A0Hello,
> =A0 =A0I found something weird in the logs.
> =A0 =A0Apparently the automated analyze process has some
> =A0 =A0problems with custom functions.
>
> =A0 =A0Using my regular database user for this db, i get no problems
> =A0 =A0using the functions which fail for the automated analyze process.
> =A0 =A0Can this be a search_path problem?

Maybe you should do ALTER FUNCTION name SET search_path =3D 'the right
search path' and see if that helps.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5305: Postgres service stops when closing Windows session
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: libpq: system-wide root.crt