Hi. I am in the process of doing some data migration. I have had no trouble moving my data, but am having problems creating a foreign key.
When I run the following command, psql hangs (well, not totally sure if it is hung). alter table t_release_component add constraint t_release_component_fk3 foreign key(parent_release_component_id) references t_release_component; The postmaster process maxes out the processor and then just sits there. The t_release_component table has 380,000 records. I am running PostgreSQL 7.1.2. Here is the output from the server log. There are many threads about this output, but I did not find any resolution. DEBUG: MoveOfflineLogs: remove 0000000100000092 DEBUG: MoveOfflineLogs: remove 0000000100000094 DEBUG: MoveOfflineLogs: remove 0000000100000095 DEBUG: MoveOfflineLogs: remove 0000000100000096 DEBUG: MoveOfflineLogs: remove 0000000100000097 DEBUG: MoveOfflineLogs: remove 0000000100000098 DEBUG: MoveOfflineLogs: remove 0000000100000099 DEBUG: MoveOfflineLogs: remove 000000010000009A DEBUG: MoveOfflineLogs: remove 000000010000009C DEBUG: MoveOfflineLogs: remove 000000010000009B Thanks for the help. Mike __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
