| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | Scott Holmes <scottholmes(at)sbcglobal(dot)net>, PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL versus MySQL |
| Date: | 2003-09-19 12:06:35 |
| Message-ID: | 200309190906.35331.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | peter pilsl | 2003-09-19 12:11:29 | 'order by' does "wrong" with unicode-chars (german umlauts) |
| Previous Message | Steve Manes | 2003-09-19 11:42:34 | DDL diff utility? |