On 3/23/21 9:18 AM, Андрей Сычёв wrote:
> Sorry, my mistake, but actually
>
> trigrams_array is called by trigrams_vector
Yes and that is at least one of the issues:
2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum
worker]-[42501]-[(at)] ERROR: permission denied for schema dict at
character 34
2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum
worker]-[42501]-[(at)] QUERY:
SELECT array_to_string(dict.trigrams_array($1), '
')::tsvector;
So who is running below and do they have permissions on schema dict?
Not sure where table fpdb.fpbackup.fp_vpn_data_2021w12 fits in? Are you
running the function against values in the table?
>
> Definition for the function dict.trigrams_vector:
>
> CREATE OR REPLACE FUNCTION dict.trigrams_vector(word text)
> RETURNS tsvector
> LANGUAGE sql
> IMMUTABLE STRICT
> AS $function$
> SELECT array_to_string(dict.trigrams_array($1), ' ')::tsvector;
> $function$
> ;
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com