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
Cheers,
D
--
=== 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
http://www.commandprompt.com/
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
