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

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?

Thanks!

Brian Ceccarelli
919-815-0126

> On Jul 7, 2018, at 3:14 AM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
>
>> On 06.07.18 18:19, PG Bug reporting form wrote:
>> I have a database with a table with a function-based check constraint.
>> The database has another table with a function-based index.
>> I dump with COPY statements (the default).
>>
>> When I load the database from the dump I just created, loading (via psql)
>> logs error messages.  Postgres cannot find functions inside the function the
>> constraint or index invokes.
>
> I think this and your subsequent report are all instances of the problem
> that pg_dump cannot see into the function body to check what database
> objects it depends on, so it cannot produce a working ordering of the
> objects.
>
> --
> Peter Eisentraut              http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services