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

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