Re: Transactional DDL - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Re: Transactional DDL
Date
Msg-id d86a77ef0706021137u7d730195v5bf09b393b3e0385@mail.gmail.com
Whole thread Raw
In response to Re: Transactional DDL  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Responses Re: Transactional DDL  (Russ Brown <pickscrape@gmail.com>)
Re: Transactional DDL  (PFC <lists@peufeu.com>)
List pgsql-general


On 6/2/07, Jasbinder Singh Bali <jsbali@gmail.com> wrote:


On 6/2/07, Michael Glaesemann < grzm@seespotcode.net> wrote:

On Jun 2, 2007, at 11:08 , Harpreet Dhaliwal wrote:

> Whats so novel about postgresql here?
> This would happen in any RDBMS. right?
> You induced divide by zero exception that crashed the whole
> transaction and it did not create the table bar?

[Please don't top-post. It makes the discussion hard to follow.]

I used the divide by zero to raise an error to show that both the
CREATE TABLE and the INSERT were rolled back when the transaction
failed. If there's another definition of transactional DDL, I'd like
to know what it is.

Michael Glaesemann
grzm seespotcode net

This is what happens in every RDBMS. Whats so special about postgres then?
 



Exactly. this seems like proving the ACIC property of a database thats true for every RDBMS.
Whats so different in postgresql then?

pgsql-general by date:

Previous
From: "Jasbinder Singh Bali"
Date:
Subject: Re: Transactional DDL
Next
From: Andrew Sullivan
Date:
Subject: Re: Slightly OT.