Re: Transactional DDL - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Re: Transactional DDL
Date
Msg-id d86a77ef0708142258h64124507j6e3508661947ce3b@mail.gmail.com
Whole thread Raw
In response to Re: Transactional DDL  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Transactional DDL
Re: Transactional DDL
List pgsql-general
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 by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Transactional DDL
Next
From: Magnus Hagander
Date:
Subject: Re: language interface in postgresql