Re: Transactional DDL - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Transactional DDL
Date
Msg-id E13618D4-93C4-4CB6-B877-9850678A4271@seespotcode.net
Whole thread Raw
In response to Re: Transactional DDL  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Responses Re: Transactional DDL  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Jeremy Harris
Date:
Subject: Re: why postgresql over other RDBMS
Next
From: "George Pavlov"
Date:
Subject: Re: query log corrupted-looking entries