Re: pg_dump and restore problem with function as DEFAULT-Constraint

Markus Schulz <msc@antzsystem.de> writes:
> i have some trouble with dumping and restoring a database with
> postgresql 7.4.7-6sarge4 (debian sarge).
> ...
> What can i do to enforce the order of plpgsql functions prior to all
> table structures?

Update to PG 8.x --- IIRC 8.0 was the first release in which pg_dump
really understood about dependencies properly.  7.x is dumping basically
in creation order, which falls down as soon as you start using ALTER
TABLE to create dependencies that weren't there originally.

            regards, tom lane