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