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 ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
