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@aklaver.com