Re: Check constraint violated

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:bcotpm$hjt$1_at_ctb-nnrp2.saix.net...
> Ed Prochak wrote:
>
> Or are you telling me that dealing with crap like this in the real world
on
> mission critical systems are fine? That having to work till the wee hours
> of the morn because of crap designs and development, is fine? (how many of
> these have you pulled recently Ed?)
>

Apparently you are surrounded by Saints. I do this all the time. I'm not aware any of my customers is abiding by the usual rules.
Tables without primary keys: happens regularly Foreign keys: please explain me what they are, never heard of it. We can't influence the SQL, or development environment is generating it. Or some dork by means of a tool on a website managed to delete half of the database (only 1 schema in that database, tools connects as the owner of the schema)
Who do you think had to repair that? The customer? Or some other dork that pulled the plug of the system *before* the UPS, just when the server was shutting down. Any idea what happened? You are in paradise and you shouldn't complain.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address