From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Jaime Soler <jaime.soler@gmail.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Subject: Re: vacuumdb -Z can't find function declared on functional index with inline sql function
Date: Thu, 19 Nov 2020 15:48:37 -0300
Message-ID: <20201119184837.GA11918@alvherre.pgsql> (raw)
In-Reply-To: <CAKVUGgQpLQWfwG2MLdJWO8p+sfMVyp8769kgsXr2h+krUOtadw@mail.gmail.com>
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$;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, jaime.soler@gmail.com
Subject: Re: vacuumdb -Z can't find function declared on functional index with inline sql function
In-Reply-To: <20201119184837.GA11918@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox