On Mon, 29 Apr 2002, Mike Baker wrote: > 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).
It probably isn't hung, but it's going to go through every row of the table to make sure the constraint holds successfully which is going to result in 380,000 queries again t_release_component. I haven't had time recently to do any of the fk stuff I've been meaning to do, but this is optimizable for most cases, but it hasn't been done. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
