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