Re: Implementing complicated constraints

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 04 Oct 2004 16:07:44 +0200
Message-ID: <cjrlfi$rjf$1@news.BelWue.DE>

Noons wrote:
> Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cjqs9v$pui$1_at_news.BelWue.DE>...
>
>

>>This is an excerpt from the docs on my prehistoric 8.0.6 CD for Windows:

>
>
> Yeah, I believe you. Did a little "digging" myself and found
> out. I'll have to understand why TK is going for FBI rather
> than instead of. Doesn't make sense.

I believe in his book (which I haven't got at hand right now) Tom explains why, maybe I get the chance for a little digging myself. My rather clumsy recollection is that this way you've declarative referential integrity and don't have to dig through the code.

>
>

>>Plus, after I moved to my current employer, I started to support an application
>>that made heavily use of views with instead of triggers. They used 8.0.6 too.
>>And if I didn't force them, they would still ...

>
>
> :) Takes all kinds, doesn't it?
> My last 8.0.6 was Feb 03. After I sent them
> a memo in early 01 explaining the dangers of staying
> with old releases, they finally decided to upgrade in
> Feb 03. Peoplesoft site. What else...

Take any customized software or worse, one of the famous home grown applications the customer wrote himself (and the original developers as well as the documentation are lost in the mist of time)... Oh, and in Feb 03 I could convince another customer at least to move from 7.3.4 to 8.1.6 which got finally disposed this summer.

Did I already tell that today(!) I was called because at another site their hp-ux 10.20/ Oracle 8.0.4 server died? Lucky ol' us that we didn't support that one. Backups exist. But no Hardware to fix or replace the old one....

Cheers,

Holger Received on Mon Oct 04 2004 - 09:07:44 CDT