in reply to (OT) Am I weasel or just right?

Since you asked, I think you could be more helpful. Honestly, this kind of "my hands are tied, it's impossible for me to touch anything ever again because it might break something" attitude is the reason why many developers end up resenting DBAs. (Note: I have known some excellent DBAs in my time who taught me many things about application design.)

If ' ' is not valid data for this database, then the DBA's job is to get rid of it and make sure it can't happen again. That's what Oracle has all of those constraint features for.

Replies are listed 'Best First'.
Re: Re: (OT) Am I weasel or just right?
by poqui (Deacon) on Sep 30, 2003 at 20:44 UTC
    I agree with perrin regarding the Oracle constraint features, but I have been in environments where constraints were considered "dirty" because they slowed down the insertion of data into the database.

    I know, it sounds odd, but thats the truth. I was on the other end trying to get usable reports and demographics out of this mess.

    I think you handled the situation correctly. Its not up to you to harangue the developer's boss.
[reply]

In Section Meditations