• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: EOF and meaningful, modifiable PKs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: EOF and meaningful, modifiable PKs
      • From: David Avendasora <email@hidden>
References: 
 >EOF and meaningful, modifiable PKs (From: Hugi Thordarson <email@hidden>)
 >Re: EOF and meaningful, modifiable PKs (From: Chuck Hill <email@hidden>)
 >Re: EOF and meaningful, modifiable PKs (From: Hugi Thordarson <email@hidden>)

  • Prev by Date: Passing data to another component
  • Next by Date: Re: Suggestions for best deployment?
  • Previous by thread: Re: EOF and meaningful, modifiable PKs
  • Next by thread: Re: EOF and meaningful, modifiable PKs
  • Index(es):
    • Date
    • Thread