Subject | RE: [firebird-support] Adding new foreign key constraints |
---|---|
Author | Alan McDonald |
Post date | 2003-06-20T10:19:55Z |
> After some tests, I've found I just can do it when nobody else isI think you'll notice that you get no errors when you do it..
> connected.
>
> Is this a common firebird rule or is it possible to change this
> behaviour?
This means that it actually does get done.. but the change you are making is
not visible to anyone until they all get off and get back on again.
This mechanism actually protects your data against situations where users
are partially thru a transaction and you go and change metadata on them mid
stream. In some cases (perhaps often) this would invalidate what they are
trying to do in their transaction.
Alan