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

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@gmx.net
>> 
>> 
>> 
>> 
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


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