Re: Transactional DDL
От
Jasbinder Singh Bali
Тема
Re: Transactional DDL
Дата
Msg-id
a47902760706020812q7867948cv37dbcf228a5627c4@mail.gmail.com
Ответ на
Re: Transactional DDL (Alexander Staubo)
Список
Дерево обсуждения
Transactional DDL "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: Transactional DDL "Alexander Staubo" <alex@purefiction.net>
Re: Transactional DDL "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: Transactional DDL "Dawid Kuroczko" <qnex42@gmail.com>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Ron Johnson <ron.l.johnson@cox.net>
Re: Transactional DDL "Leif B. Kristensen" <leif@solumslekt.org>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL David Fetter <david@fetter.org>
Re: Transactional DDL Michael Glaesemann <grzm@seespotcode.net>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Michael Glaesemann <grzm@seespotcode.net>
Re: Transactional DDL "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: Transactional DDL Ron Johnson <ron.l.johnson@cox.net>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Russ Brown <pickscrape@gmail.com>
Re: Transactional DDL Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactional DDL "Jaime Casanova" <systemguards@gmail.com>
Re: Transactional DDL PFC <lists@peufeu.com>
Re: Transactional DDL "Jaime Casanova" <systemguards@gmail.com>
Re: Transactional DDL Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactional DDL PFC <lists@peufeu.com>
But its said that transactions in any RDBMS follow ACID properties.
So if i put a create table and an Insert statement in the same begin end block as one single transactioin, won't both create and insert follow acid property, being in one single trasaction, and either both get committed or none, talking about oracle lets say
So if i put a create table and an Insert statement in the same begin end block as one single transactioin, won't both create and insert follow acid property, being in one single trasaction, and either both get committed or none, talking about oracle lets say
On 6/2/07, Alexander Staubo <alex@purefiction.net> wrote:
On 6/2/07, Jasbinder Singh Bali <jsbali@gmail.com> wrote:
[snip]
> I believe that if a database supports transactional ddl then ddl1 and ddl2
> would commit together as a batch
> And
> If a Db doesn't support this transactional DDL feature then ddl1 executes
> and commits without even caring about ddl2. Right?
Exactly right -- Oracle, for example, implicitly commits the
transaction when you execute a DDL statement such as "create table".
Alexander.
В списке pgsql-general по дате отправления
