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

From: Jaime Soler <jaime(dot)soler(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: vacuumdb -Z can't find function declared on functional index with inline sql function
Date: 2020-11-20 08:20:01
Message-ID: CAKVUGgTf2caT5DiyoBdJwUJeXpkDAAYxfmCv1XZ6Vb=0055z0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Great info, thanks for your help. This was that case, a migration database
from v9.6 to v13.1

El vie, 20 nov 2020 a las 0:22, David G. Johnston (<
david(dot)g(dot)johnston(at)gmail(dot)com>) escribió:

> On Thu, Nov 19, 2020 at 3:54 PM Jaime Soler <jaime(dot)soler(at)gmail(dot)com> wrote:
>
>> thanks Alvaro, I don't know why I suppose that prior releases of vacuumdb
>> will use the user's search_path .
>>
>
> search_path for non-interactive uses became (IMO) functionally obsolete a
> while back:
>
>
> https://www.postgresql.org/about/news/postgresql-103-968-9512-9417-and-9322-released-1834/
>
> David J.
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sofoklis Papasofokli 2020-11-20 10:32:18 Re: BUG #16730: Create table like with inheritance and self referencing index
Previous Message Dilip Kumar 2020-11-20 06:05:59 Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop