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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Patric de Waha <lists(at)p-dw(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Automated analyze process fails with custom function, which works perfect as regular user (8.4.2).
Date: 2010-08-20 01:46:10
Message-ID: AANLkTi=6jtw2nQL7FpFYsaNEj=KE7j1cDcgD4XWpuWAo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 9, 2010 at 3:59 AM, Patric de Waha <lists(at)p-dw(dot)com> wrote:
>  Hello,
>    I found something weird in the logs.
>    Apparently the automated analyze process has some
>    problems with custom functions.
>
>    Using my regular database user for this db, i get no problems
>    using the functions which fail for the automated analyze process.
>    Can this be a search_path problem?

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

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Soporte @ Teksol SA 2010-08-20 11:55:22 Re: BUG #5305: Postgres service stops when closing Windows session
Previous Message Robert Haas 2010-08-20 01:43:02 Re: BUG #5305: Postgres service stops when closing Windows session