On 04/29/2014 12:03 PM, Vlad Khorsun wrote: >>> 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. >
One exception - when we need to reflect in system tables changes in underlying file system. I mean first of all additional files (like shadows). Here automatic rollback of user transaction may play bad things, i.e. loose sync between system table and file system. ------------------------------------------------------------------------------ "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
