Re: To Postgres or not - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: To Postgres or not
Date
Msg-id 1121328521.20011.21.camel@sabrina.peacock.de
Whole thread Raw
In response to Re: To Postgres or not  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
Am Donnerstag, den 14.07.2005, 00:57 -0400 schrieb Alvaro Herrera:
> On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
> > Vivek Khera wrote:
> > >The first sentence rules out MySQL, so the second sentence should  read
> > >"So that leaves Postgres".  Your problem is solved ;-)
> > >
> > >(If you are accustomed to Oracle, you are probably expecting an ACID
> > >database, which rules out MySQL too).
> >
> > Does MySQL with InnoDB not qualify as an ACID-compliant database?
>
> Not if you intermix InnoDB tables with MyISAM tables, which AFAIK many
> people seem to do.

Even not in a clean InnoDB environment because still data is silently
truncated. (e.g. smallint takes 200 and truncates it to 127. Thats not
ACID :)




pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: Case insensitive unique constraint
Next
From: Andreas Seltenreich
Date:
Subject: Re: Case insensitive unique constraint