Re: Transactional DDL - Mailing list pgsql-general

From Alexander Staubo
Subject Re: Transactional DDL
Date
Msg-id 88daf38c0706020751h49a99f7bifae3fce84ffebaed@mail.gmail.com
Whole thread Raw
In response to Transactional DDL  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Responses Re: Transactional DDL  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List pgsql-general
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 by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: Stored Procedures and Functions
Next
From: Tom Lane
Date:
Subject: Re: Corruption of files in PostgreSQL