David Fetter wrote:
On Fri, Apr 06, 2007 at 09:22:55AM -0700, Joshua D. Drake wrote:

The people that use it are the people stuck by dogmatic rules about
"every table must have a primary key" or "every logical constraint
must be protected by a database constraint". Ie, database shops run
by the CYA principle.
Or ones that actually believe that every table where possible should
have a primary key.

There are very, very few instances in good design where a table does
not have a primary key.

It has nothing to do with CYA.

That depends on what you mean by CYA.  If you mean, "taking a
precaution just so you can show it's not your fault when the mature
hits the fan," I agree.  If you mean, "taking a precaution that will
actually prevent a problem from occurring in the first place," it
definitely does.

Heh, fair enough. When I think of CYA, I think of the former.

Joshua D. Drake



      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to