Re: PostgreSQL versus MySQL - Mailing list pgsql-general

From Martin Marques
Subject Re: PostgreSQL versus MySQL
Date
Msg-id 200309190906.35331.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: PostgreSQL versus MySQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: PostgreSQL versus MySQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
El Jue 18 Sep 2003 20:34, scott.marlowe escribió:
>
> they still claim to have ACID compliance, an issue I've discussed with a
> few of the folks from MySQL AB.  To them, the C in ACID only implies fk
> constraints.  The fact that they ignore base type constraints (i.e. insert
> 8 billion into an int4 and it just sets the field to the max value an int4
> can hold (2gig) and generates no error seems to not bother them.

You mean that when they hit the limit, all other inserts have the MAX value?
That would be terrible!

--
 09:05:01 up 28 days, 55 min,  2 users,  load average: 1.25, 0.60, 0.38
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: adding on delete cascade constraint?
Next
From: Richard Huxton
Date:
Subject: Re: Column defaults fail with rules on view