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
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-advocacy by date

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

Browse pgsql-general by date

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