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 Peter Eisentraut
Subject Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices
Date
Msg-id 5a5639f6-5807-2856-8893-1d81c0102b24@2ndquadrant.com
Whole thread Raw
In response to Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices  ("ceccareb@talusmusic.com" <ceccareb@talusmusic.com>)
Responses Re: BUG #15263: pg_dump / psql failure. When loading, psql does notsee function-based constraints or indices
List pgsql-bugs
Tree view 
On 07.07.18 16:50, ceccareb@talusmusic.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore: All GRANTs on table fail when any one role is missing
Next
From: 李海龙
Date:
Subject: function lca('{}'::ltree[]) caused DB Instance crash