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: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Date: 2003-08-23 10:57:36
Message-ID: Pine.LNX.4.21.0308231220120.22590-100000@tiger.tigrasoft.hu (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers

<off>
Yep, I know, but that is not a reason. :)
</off>

Laci

On Fri, 22 Aug 2003, Jan Wieck wrote:

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


In response to

pgsql-hackers by date

Next:From: JeffDate: 2003-08-23 13:31:27
Subject: Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous:From: Andrew DunstanDate: 2003-08-23 10:33:35
Subject: Re: Single-file DBs WAS: Need concrete 'Why Postgres

pgsql-advocacy by date

Next:From: JeffDate: 2003-08-23 13:31:27
Subject: Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous:From: Andrew DunstanDate: 2003-08-23 10:33:35
Subject: Re: Single-file DBs WAS: Need concrete 'Why Postgres

pgsql-general by date

Next:From: JeffDate: 2003-08-23 13:31:27
Subject: Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous:From: Andrew DunstanDate: 2003-08-23 10:33:35
Subject: Re: Single-file DBs WAS: Need concrete 'Why Postgres

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