Re: BUG #16534: autovacuum_autoanalyze not working on latitude(earth) expression

I don't fully understand the matter, but how I read it, it is a
problem between extensions calling each other's functions? How is this
only an issue when the background workers are autovacuuming? When I
manually analyze the table, no errors whatsoever. Is this because of
the search path which is set when I execute the query from pgadmin?

Regards, Martin Winkel

________________________________
Van: Sergei Kornilov <sk(at)zsrv(dot)org>
verzonden: vrijdag 10 juli 2020 21:58
Aan: Tom Lane; martin(at)tiogatours(dot)nl
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Onderwerp: Re: BUG #16534: autovacuum_autoanalyze not working on
latitude(earth) expression

Hello

> Possibly at some point somebody will care enough to patch the module
> to attach "SET search_path" clauses to all the SQL functions.

I tried. But such idea was rejected because will prevent function
inlining, confuses relocated extensions, and fix only this extension.
https://www.postgresql.org/message-id/flat/15530-3dc5f66205393dc0%40postgresql.org

regards, Sergei