pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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$;






view thread (6+ messages)  latest in thread

Message-ID: <20201119184837.GA11918@alvherre.pgsql>
Permalink:  ../20201119184837.GA11918@alvherre.pgsql/
Also on:    postgresql.org/message-id/20201119184837.GA11918@alvherre.pgsql

 · 

reply

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