Re: vacuumdb -Z can't find function declared on functional index with inline sql function

thanks Alvaro, I don't know why I suppose that prior releases of vacuumdb
will use the user's search_path .

El jue, 19 nov 2020 a las 19:48, Alvaro Herrera (<alvherre(at)alvh(dot)no-ip(dot)org>)
escribió:

> On 2020-Nov-19, Jaime Soler wrote:
>
>
> > CREATE OR REPLACE FUNCTION public.tecnologia_index_func(nombre character
> > varying, tipotec bigint)
> > RETURNS text
> > LANGUAGE sql
> > IMMUTABLE
> > AS $function$
> > select tipotec || '_' || upper(sinacentos(trim(nombre)));
> > $function$
>
> This should be fixable by either schema-qualifying function
> 'sinacentos', or adding a SET search_path clause to the function.
>
> CREATE OR REPLACE FUNCTION public.tecnologia_index_func(nombre character
> varying, tipotec bigint)
> RETURNS text
> LANGUAGE sql
> IMMUTABLE
> AS $function$
> select tipotec || '_' || upper(public.sinacentos(trim(nombre)));
> $function$;
>
>