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