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

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$;