Re: Transactional DDL

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
Cc: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, "Alexander Staubo" <alex(at)purefiction(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Transactional DDL
Date: 2007-06-02 18:37:32
Message-ID: d86a77ef0706021137u7d730195v5bf09b393b3e0385@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:
>
>
>
> On 6/2/07, Michael Glaesemann <grzm(at)seespotcode(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-06-02 18:39:10 Re: Transactional DDL
Previous Message Jasbinder Singh Bali 2007-06-02 18:35:58 Re: Transactional DDL