Hi,

during maintenance I saw a lot of lines in my postgreslog saying:
CONTEXT:  SQL function "line_function" during inlining
        automatic analyze of table "osm.planet_osm_line"
ERROR:  operator does not exist: public.hstore -> unknown at character 45
HINT:  No operator matches the given name and argument types. You might
need to add explicit type casts.

Now the hint gives me an option but I really don't like the sprinkling of
::text in all my functions
When executed (with search_path=public) this function works correctly, and
I doublechecked that all (or at least a lot of them) hstore related
functions are present in the public schema.
Are there any other solutions to this?

Paul

PS please cc me when answering

Reply via email to