Postgres Pro
Downloads
Home   >   mailing lists

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

From Jaime Soler
Subject Re: vacuumdb -Z can't find function declared on functional index with inline sql function
Date
Msg-id CAKVUGgTf2caT5DiyoBdJwUJeXpkDAAYxfmCv1XZ6Vb=0055z0A@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb -Z can't find function declared on functional index with inline sql function  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
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.g.johnston@gmail.com>) escribió:
On Thu, Nov 19, 2020 at 3:54 PM Jaime Soler <jaime.soler@gmail.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.

pgsql-bugs by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop
Next
From: Sofoklis Papasofokli
Date:
Subject: Re: BUG #16730: Create table like with inheritance and self referencing index