Re: Transactional DDL

From: "Alexander Staubo" <alex(at)purefiction(dot)net>
To: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Transactional DDL
Date: 2007-06-02 14:51:20
Message-ID: 88daf38c0706020751h49a99f7bifae3fce84ffebaed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/2/07, Jasbinder Singh Bali <jsbali(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-02 14:54:16 Re: Corruption of files in PostgreSQL
Previous Message Harpreet Dhaliwal 2007-06-02 14:47:43 Stored Procedures and Functions