ALTER TABLE hangs

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