Re: PostgreSQL not ACID compliant? - Mailing list pgsql-hackers

On Fri, 19 Sep 2003, Joshua D. Drake wrote:

> Hello,
>
>   Sorry guys I made the unbelievable mistake of talking on the #mysql
> channel today. Can you believe that they
> actually feel that the fact that you can insert data outside the
> boundaries of the data type (int for example) and
> mySQL won't throw an exception is still valid ACID compliance.
>
>   There argument is that the application (user) should not have tried to
> insert bad data. I was completely blown
> away. The C in ACID explictly states that internal (data type boundaries
> anyone) AND user defined constraints
> can not be violated.
>
>   I am just flabbergasted. I am going to come back to my safe PostgreSQL
> world.

Boy, I'm flabbergasted that you actually believed them ... tsk tsk ...