Re: To Postgres or not

On Wed, 2005-07-13 at 23:57, Alvaro Herrera wrote:
> 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.

And the tendency to NOT throw errors or warnings is frightening.

create table blah (field1 int, field2 text) type=inoodb

will gladly create a myisam table, no warnings, no errors, nothing
else. Then if you try to start a transaction on it, it quietly starts
it, no errors again, until you try to roll it back.

Sorry, but that does NOT qualify as ACID, no matter what some folks may
say on their blogs.