The add constraint foreign key dialog does not appear to be working correctly. It doesn't offer any column choices in the 'referencing' drop down box in the columns tab. I have a table selected that has the primary key column I am trying to reference.
I can't reproduce this. This sounds like what happens when the tables don't have pks.
Also, if I want to create a foreign key that
references the primary key in the same table
('child_of' type columns), I am not able to do a self
reference to the table untill after it has been fully
created.
This is by design, only already existent tables can be selected at creation time.
Although it's perfectly legal, self references might lead to trouble under some maintenance circumstances, so I'd recommend to avoid them.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
