Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: firstname lastname <ceccareb(at)talusmusic(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices
Date: 2018-07-18 22:04:31
Message-ID: 20180718220431.b6dmz7z3i7imi2ux@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018-Jul-18, firstname lastname wrote:

> Peter,
>
> Both of your suggestions work. I opted to change the search path in
> the dump file. The alternative is is to prefix "public" to hundreds
> of functions. I do not want to do that. Too much work.

Hmm, surely you can just do "ALTER FUNCTION ... SET search_path" in a DO
block that processes all functions, or something to that effect.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-07-18 22:10:13 Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices
Previous Message firstname lastname 2018-07-18 21:47:40 Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices