Re: Integrity on large sites - Mailing list pgsql-general

From Stuart Cooper
Subject Re: Integrity on large sites
Date
Msg-id 7fc8628a0705221927w632b9b16vd0b98fe7525ccb2d@mail.gmail.com
Whole thread Raw
In response to Integrity on large sites  (Naz Gassiep <naz@mira.net>)
List pgsql-general
> "*Really* big sites don't ever have referential integrity. Or if the few
> spots they do (like with financial transactions) it's implemented on the
> application level (via, say, optimistic locking), never the database level."

Some large sites don't even use data types!

http://www.thestar.com/News/article/189175

"in some cases the field for the social insurance number was instead
filled in with a birth date."

(search the archives for "OT: Canadian Tax Database")

Cheers,
Stuart.

pgsql-general by date:

Previous
From: Naz Gassiep
Date:
Subject: Integrity on large sites
Next
From: "Richard P. Welty"
Date:
Subject: Re: Integrity on large sites