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