On 3/23/21 9:45 AM, Андрей Сычёв wrote:
I do not know who is running dict.trigrams_vector. There is no explicit call for this function. It is used implicitly in the index definition for the table fpbackup.fp_vpn_data_2021w12: CREATE INDEX fp_vpn_data_2021w12_trigrams_vector_idx ON fpbackup.fp_vpn_data_2021w12 USING gin (dict.trigrams_vector((fp_host)::text));
Aah, I missed that.
As I know there is no explicit call for dict.trigrams_vector by me or anyone else.
The error is happening when the auto analyze opens the index on the table, though I will have to admit that I don't know why?
What happens if you do a manual ANALYZE on the table?
From the database logs I cannot figure out what user is responsible for calling this function as user field in the log in ordinary situation should be, for example, [user@dbname], not [(at)]
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
