Re: Check constraints, the impossible dream?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 22 Mar 2002 20:59:19 -0000
Message-ID: <3c9ba9da_3@mk-nntp-1.news.uk.worldonline.com>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1016789197.26136.0.nnrp-10.9e984b29_at_news.demon.co.uk...
>
> Please ignore the more abrasive comments from Daniel
> Morgan, he used to think he was an Oracle expert, and now
> that he's read Tom Kyte's book he "knows" that he is.
>
> Tom Kyte, however, demonstrates the need for
> patience, explanation and proof - which Daniel
> Morgan seems to have overlooked.
>

<snip good sound stuff>

Jonathan,

My colleagues and I had a dilemma over this when we went over to Oracle in 1995.
Our conclusion was that under most circumstances, the optimum solution for an OLTP app is to validate twice over; catch it in the client with a meaningful message for the user, *and* have the db as a sort of wicketkeeper.
Someone wrote 'keep the application honest'; as a DBA that seems a reasonable approach.
What do you think?

Paul Received on Fri Mar 22 2002 - 14:59:19 CST