Re: Adding foreign keys

Trent Oliphant wrote:
> 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