Subject Re: [firebird-support] Cannot add a column constraint with another connection open?
Author Ann W. Harrison
phil_hhn wrote:
> Is it that firebird doesn't allow the second app to do things which
> may affect system tables that may affect the first application?

There is a specific restriction on adding referential constraints that
is removed by Firebird 2. The problem is that all users must instantly
obey relational constraints and Borland didn't bother to create a
mechanism that worked in classic where different clients are in
different processes.