Re: Transactional DDL

Поиск
Список
Период
Сортировка
Искать
От
Harpreet Dhaliwal
Тема
Re: Transactional DDL
Дата
Msg-id
d86a77ef0708142258h64124507j6e3508661947ce3b@mail.gmail.com
Ответ на
Re: Transactional DDL (Scott Marlowe)
Список
Дерево обсуждения
Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Ron Johnson <ron.l.johnson@cox.net>
Re: Transactional DDL Chris <dmagick@gmail.com>
Re: Transactional DDL Greg Williamson <Gregory.Williamson@digitalglobe.com>
Re: Transactional DDL "Alexander Staubo" <alex@purefiction.net>
Re: Transactional DDL "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Transactional DDL Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Transactional DDL Tino Wildenhain <tino@wildenhain.de>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Transactional DDL "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Transactional DDL Jan de Visser <jdevisser@digitalfairway.com>
Re: Transactional DDL Magnus Hagander <magnus@hagander.net>
So you mean to say something like this as far as oracle is concerned:

BEGIN
      DDL 1 (commits right after its execution)
      DDL 2 (commits right after its execution)
END

That means there's no concept of putting DDL statements in a transaction in oracle basically, right?

Thanks,
~Harpreet

On 8/15/07, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On 8/14/07, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com> wrote:
> So you mean to say DDL statements can't be put in one single transaction in
> Oracle ?

You can put them in, but then they will cause the previous DMK to be
silently committed

В списке pgsql-general по дате отправления
От: Scott Marlowe
Дата:
Сообщение: Re: Transactional DDL
От: Magnus Hagander
Дата:
FAQ