> You'll probably end up using ALTER TABLE ADD CONSTRAINT to add the > constraints to the new master_table. It's possible that you might > be able to hack something with the system tables, but that sounds > dangerous. Or you can upgrade to 7.3 which lets you run alter table > drop column. :) If it is the only way, I can create >20 "alter table add constraint...", but is rather a boring finish :-( I found, I can dump database - data only. After this I can create all tables and restore data.
Any other solution? Tomasz Myrta ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
