Subject Re: [firebird-support] Re: Cannot add a column constraint with another connection open?
Author Ann W. Harrison
phil_hhn wrote:
>>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.
> Ah. Is that problem in classic only? We're using 1.5.2 superserver...
No. Because there wasn't a general solution, Borland applied a limit on
all users - regardless of server configuration.