ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Leaving a table without a primary key makes the schema designer hang #776

Open MerielP opened 8 years ago

MerielP commented 8 years ago

To reproduce this:

The result is that the schema designer whirrs away as if it's processing something, but never reaches a conclusion. The buttons are all disabled when this happens: the only way I've found of getting out of it is to refresh the schema designer, or to exit it by using the browser's 'Back' button. (This of course means any changes made since the last save are lost.)

It's perfectly reasonable for ORDS to object to a table being left without a primary key, but the user needs to be alerted to this. Ideally, what would happen is that clicking 'OK' after removing the primary key (and not replacing it) would trigger a warning saying that the table must have a primary key, so the 'Keys' dialogue box can't be closed until a new key has been added.