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@xxxxxxxxxxx
