Firebird 1.0.3 on Windows XP when creaing a foreign key it hangs
Firebird. Either creting it from IBExpert or Delphi's SQL Explorer.

SQL statement has no errors. It is created with IBExpert. Master table
has unique primary key. In IBexpert when I click compile I get status
"successful", but when I do commit it just hangs (Not responding). SQL
Explorer just hangs (Not responding) after clicking Execute query button.

What could be reasons for this?

this detail table already has one foreign key what works fine. can one
detail table have more than one foreign keys to different tables?