Quick Links

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

From:	"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To:	Jaime Soler <jaime(dot)soler(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-19 23:22:10
Message-ID:	CAKFQuwaTRb+J3C0UsY0pSCS8i0PALdBXZSZpfrJ0L-AF3tzutg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

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:

David J.

	From	Date	Subject
Next Message	PG Bug reporting form	2020-11-20 01:13:12	BUG #16732: pg_dump creates broken backups
Previous Message	Jaime Soler	2020-11-19 22:53:58	Re: vacuumdb -Z can't find function declared on functional index with inline sql function