Hello,
i have some trouble with dumping and restoring a database with
postgresql 7.4.7-6sarge4 (debian sarge).
Some tables have plpgsql-functions as DEFAULT contraints. But these
functions are dumped after the CREATE TABLE command. Now these tables
can't be created on restore.
If i'm dumping only structure and import twice in a new and empty
database (this works), i can't restore the data-only dump. Cause in the
data-only dump the table order was wrong in respect to FOREIGN KEY
constraints and the constraints are now active (instead of a full-dump,
where constraints will be created after data was inserted).
Why DEFAULT (and NOT NULL) constraints would'nt be added after data
insertion? (like Primary-Key and Foreign-Key)
What can i do to enforce the order of plpgsql functions prior to all
table structures?
--
Markus Schulz - msc@antzsystem.de