Sample Header Ad - 728x90

'text search dictionary "unaccent" does not exist' entries in postgres log, supposedly during automatic analyze

3 votes
1 answer
4789 views
I have many such entries in the postgresql main log, ever since upgrading to Postgres 10: 2018-03-28 08:51:00.281 CEST ERROR: text search dictionary "unaccent" does not exist 2018-03-28 08:51:00.281 CEST CONTEXT: automatic analyze of table "dbname.public.periodical" I do use unaccent in many indexes in all tables (by making unaccent immutable (I know it is not the recommended way, but it is so historically)). If I manually run vacuumdb dbname --table periodical or VACUUM periodical or VACUUM ANALYZE periodical, it does not generate such an error (neither on the command line, nor in the log). Does anyone have a tip how I could stop these messages and what their real cause may be? PostgreSQL version: 10.3 (Debian 10.3-1.pgdg80+1)
Asked by P.Péter (911 rep)
Mar 28, 2018, 07:19 AM
Last activity: Dec 10, 2018, 12:01 PM