Subject Re: [firebird-support] Online DDL
Author Carlos H. Cantu
Post date 2014-03-22T23:55:06Z
Re: [firebird-support] Online DDL No, corruption can happen if you mix DDL and DML in the same transaction. If you "commit" between them, you are safe.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br



El 23/03/2014, a las 00:44, "Carlos H. Cantu" <listas@...> escribió:

 
It depends on what kind of changes you plan to do. Some of them still
needs exclusive access, otherwise you may end up with an "object is in
use" error.

I think Aldo asks If it is "sure", because there are comments, some recent, that changing metadata while users connected can cause database corruption.

Of course, If object in use raises, is not a problem, only if the database stay in the prior state after the error, but is a problem if trying to drop a table can cause database corruption.

Jesus Garcia