Subject Re: [firebird-support] Re: Rules for Metadata changes when DB is on-line
Author Ann W. Harrison
tomconlon7777777 wrote:
>>>Basically definitive information is what is being requested.
> Does anyone, anywhere know what/where this information is?
To the best of my knowledge, it's not documented - in part because most
of the developers consider that all metadata updates should be possible
on a live database with the following two caveats:

1) No one is allowed to access an object if there are uncommitted
metadata changes on the object. We could (but don't) enforce that.

2) Some metadata changes (e.g. building a new index) will quiesce all
changes to the object being changed. We do enforce that.

V2.0 removes the last known enforced limit on live metadata changes by
allowing foreign keys to be defined on a live database. Over time,
we'll get the bugs that make on-line metadata updates questionable.