Re: No enough privileges for autovacuum worker

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(dot)klaver(at)aklaver(dot)com