From: Adriano d. S. F. <adr...@gm...> - 2014-04-29 00:24:15
|
On 28-04-2014 19:02, Dimitry Sibiryakov wrote: > 28.04.2014 23:21, Claudio Valderrama C. wrote: >> I know people will feel outraged with my opinion, but anyway: make DDL >> operations atomic and immediate. Uncommitted DDL and DML working in unison >> with stable DB structure is a naive dream, period. > > I may be wrong as often, but AFAIU this dream may be a reality if: > > 1) Eliminate DFW > 2) Perform DDL (operations with system tables) in user transaction > 3) Make garbage collector to handle system tables well > > MVCC will do the rest automagically. > Not so simple. With the current way that Firebird validate objects, not (or trying) allowing invalid interdependencies after commit, you'll not be able to do changes. Auto-commit DDL requires object invalidation. Adriano |