Whether or not the default table type is changed to InnoDB, in the
spirit of the original poster's question, and what I think Sinisa is
trying to get you to admit, transaction support is no longer one of the
issues to consider when comparing MySQL to PostgreSQL.  MySQL supports
transactions *now*.

Transactions "everywhere" is really a meanlingless comparison point.  If
anything, MySQL wins on this point.  What if I don't want it everywhere?
Point being, in MySQL you have a choice.

That said, depending on your requirements, there are still compelling
reasons to choose PostgreSQL - subselects, triggers, user defined types,
etc.

> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]] On Behalf Of Trond 
> Eivind Glomsrød
> Sent: Wednesday, February 06, 2002 3:15 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: PostgreSQL
> 
> 
> Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> 
> > Trond Eivind Glomsrød writes:
> > > Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> > > 
> > > There is a slight difference between advanced, non-standardized 
> > > tuning/backup/load-balancing like that and core SQL functionality 
> > > not being present.
> > 
> > This depends on the definition. Where do you draw your definitions 
> > from ??
> > 
> > And core SQL functionlity that we speak about IS present.
> 
> Transactions are present, but not in the default table type 
> (MyISAM). My understanding is that this will change in MySQL 4.
> 
> -- 
> Trond Eivind Glomsrød
> Red Hat, Inc.
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to