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

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

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Date: 2003-08-22 14:25:57
Message-ID: 3F4627F5.2040908@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
Hornyak Laszlo wrote:

> 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?

Go to http://www.mysql.com, type "postgresql" into the search field (top 
right corner) and read through some of the links. Especially stuff like 
the subsections of

     http://www.mysql.com/doc/en/Compare_PostgreSQL.html

Then go to http://www.postgresql.org and try to find similar FUD. You 
will rather find something like this:

     http://developer.postgresql.org/~petere/comparison.html

This exercise will tell you who considers whom "enemy" and why some of 
us just "dislike" MySQL and their understanding of "fair".


Jan

> 
> 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)
>> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #


In response to

Responses

pgsql-hackers by date

Next:From: Jan WieckDate: 2003-08-22 14:36:19
Subject: Re: Buglist
Previous:From: Manfred KoizarDate: 2003-08-22 14:09:44
Subject: Re: Buglist

pgsql-advocacy by date

Next:From: AutoresponderDate: 2003-08-22 15:26:48
Subject: Re: Details
Previous:From: AutoresponderDate: 2003-08-22 12:16:44
Subject: Re: Thank you!

pgsql-general by date

Next:From: Carmen Gloria Sepulveda DedesDate: 2003-08-22 14:28:56
Subject: Re: Schema
Previous:From: Dennis BjörklundDate: 2003-08-22 14:25:30
Subject: Re: Schema

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