>> I know people will feel outraged with my opinion, but anyway: make DDL >> operations atomic and immediate.
This is the "Oracle way". > Atomic and immediate means autocommitted or always executed in a > separate (e.g. system) transaction? I have strong opinion that system transaction must be read-only. Current way to undo actions made by system transaction is fragile (to say softly). So, i see autocommit as only possibility, if we choose "Oracle way" >> Uncommitted DDL and DML working in unison >> with stable DB structure is a naive dream, period. > > Maybe true for the current FB code, but not generally. Other databases > can handle this reliably. MSSQL, for example. Regards, Vlad ------------------------------------------------------------------------------ "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