Re: No enough privileges for autovacuum worker - Mailing list pgsql-general

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