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

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: "ceccareb(at)talusmusic(dot)com" <ceccareb(at)talusmusic(dot)com>
Cc: 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-13 08:19:14
Message-ID: 5a5639f6-5807-2856-8893-1d81c0102b24@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 07.07.18 16:50, ceccareb(at)talusmusic(dot)com wrote:
> Seems like a reasonable diagnosis. Apparently someone introduced this problem into 10.x. 9 works fine.
>
> Is there anything I can do? Or do know if someone is trying to fix this one?

It looks like you might need to fix up your functions to handle schema
search path changes. Either do SET search_path inside the function or
attached to the function definition, or explicitly schema-qualify the
function calls.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 李海龙 2018-07-13 10:09:20 function lca('{}'::ltree[]) caused DB Instance crash
Previous Message Tom Lane 2018-07-12 22:07:42 Re: pg_restore: All GRANTs on table fail when any one role is missing