Markus Schulz <msc@xxxxxxxxxxxxx> 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
