We had these same problems creating Foreign keys on tables when there
were open connections to the database. The problems seemed to go away
once we made sure that no one else was on the database while we ran the
update scripts.

-steve

On Tue, 2005-06-14 at 16:44 +0300, Raigo wrote:

> 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?
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]