Subject Re: [firebird-support] Creating foreign keys
Author Lucas Franzen
marcel_nic schrieb:
> Hi all,
> I'm trying to create a foreign key between 2 tables while 2 or more
> connections to the database are active and I get an error like this
> This operation is not defined for system tables.
> unsuccessful metadata update.
> object REFERENCED_TABLE is in use
> Is this a normal behaviour (while any other changes are alowed - i.e.
> add or delete fields, delete FK-s)

it's standard behaviour for creating foreign keys.
You have to have single access to the database if you want to do this.

You can add or delete fields without this, but as a rule just do
metadata changes only when NOONE else is connected to the database and
you're better off with re-starting your connection before doing so.