Re: Autovacuum analyze can't find C based function - Mailing list pgsql-bugs

From Thomas Butz
Subject Re: Autovacuum analyze can't find C based function
Date
Msg-id 2003798392.33.1531988965573.JavaMail.tbutz@BART
Whole thread Raw
In response to Re: Autovacuum analyze can't find C based function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Autovacuum analyze can't find C based function
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> writes:
> In recent PG releases, autovacuum executes stuff under a restrictive
> search_path setting (just pg_catalog, in fact).

This should probably be added to section 24.1. of the documentation. At least i couldn't find it elsewhere.

> So you need to do something explicit to reference stuff in other schemas; either schema
> qualify the name

That solved my problem. Now the autovacuum daemon is able to find the function.

> or add a "SET search_path" clause to the function
>definition.

Could you elaborate a bit more on this? It seems like this would only limit/change which objects should be accessed
within the function as described by the CREATE FUNCTION documentation. The function itself wouldn't still be picked
up by the autovacuum daemon or am i missing something?

> This is good practice anyway: what you're seeing is that this
> function fails with any search_path other than the one you use by default.
> 
>             regards, tom lane


-- 
Best regards


Thomas Butz


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15284: SSL connection is off
Next
From: Quân Vũ Quốc
Date:
Subject: Domain: Peer's Certificate has expired