Re: EOF and meaningful, modifiable PKs
Re: EOF and meaningful, modifiable PKs
- Subject: Re: EOF and meaningful, modifiable PKs
- From: Chuck Hill <email@hidden>
- Date: Tue, 27 Jul 2010 09:13:43 -0700
On Jul 27, 2010, at 3:18 AM, Hugi Thordarson wrote:
> Good morning!
>
>
> On 14.7.2010, at 17:32, Chuck Hill wrote:
>
>> User. Modifiable. PK. WTF?!!? Icelandic banking systems? :-P
>
> I wish - unfortunately it's the Icelandic Vehicle Registry, meaning *I* have to fix this :).
Shudder.
> For legacy reasons, I can't ditch the old PKs entirely in favor of new ones - which also sucks.
>>
>> Are the users still going to be modifying them? How did they handle that? Update all the FKs in the same transaction?
>
> Yes, they will continue to be modified, and yes, that's how it's handled today. For example, the date a vehicle is inspected is part of the PK. Update that date, and you'll have to update about a billion FKs.
Be a terrible shame if the servers fell into one of your volcanoes. Just terrible.
Who made this awful design? Be a terrible shame if they fell into a volcano too.
>> Run away?
>
> Yes. Yes, that's exactly what I'm thinking… :)
Wow. I have nothing more to say. Wow. That belongs here: http://thedailywtf.com
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden