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