Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Need concrete "Why Postgres not MySQL"

From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Date: 2003-08-22 06:30:24
Message-ID: Pine.LNX.4.21.0308220805290.11798-100000@tiger.tigrasoft.hu (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
Hi all!

Can someone explain me why is it usefull if the table created in
transaction disapears on rollback?
Anyway the progress db supports it, at least the version 9.
The other question: why is mysql enemy? Isn`t it just another RDBMS?

Thanks,
Laszlo

On Thu, 21 Aug 2003, Ian Barwick wrote:

> On Thursday 21 August 2003 11:15, Shridhar Daithankar wrote:
> > On 21 Aug 2003 at 0:22, Ian Barwick wrote:
> > > * DDL
> > > - Data definition language (table creation statements etc.) in MySQL
> > > are not transaction based and cannot be rolled back.
> >
> > Just wondering, what other databases has transactable DDLs? oracle seems to
> > have autonomous transactions which is arthogonal.
> 
> DB2 8.1 seems to support transaction-capable DDL. At least, a rollback
> following a CREATE TABLE causes the table to disappear. Haven't gone
> into it in any depth.
> 
> 
> Ian Barwick
> barwick(at)gmx(dot)net
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 


In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2003-08-22 06:40:32
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Previous:From: Christopher Kings-LynneDate: 2003-08-22 01:40:45
Subject: Re: [SQL] "SELECT IN" Still Broken in 7.4b

pgsql-advocacy by date

Next:From: Christopher Kings-LynneDate: 2003-08-22 06:40:32
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Previous:From: AutoresponderDate: 2003-08-22 05:37:39
Subject: Re: That movie

pgsql-general by date

Next:From: Christopher Kings-LynneDate: 2003-08-22 06:40:32
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Previous:From: Shridhar DaithankarDate: 2003-08-22 06:26:16
Subject: Re: 7.4b1 vs 7.3.4 performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group