Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices
Date
Msg-id 20180718220431.b6dmz7z3i7imi2ux@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices  (firstname lastname <ceccareb@talusmusic.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: firstname lastname
Date:
Subject: Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices