longdescs no pk?

Joel Peshkin bugreport at peshkin.net
Mon Nov 3 23:14:18 UTC 2003


Christopher Hicks wrote:

>(1) Why doesn't the longdesc table have a primary key?
>
>(2) Would there be any harm in putting an autoincrement key or something
>in there?  I can't think of any reason why it would, but my imagination is
>currently unusually limited by the sensory overload of being at an
>insurance conference at the Opryland.  I wish I was kidding.  :)
>
>(3) Is there a preferred official solution to this?  It would seem like a
>primary key across bug_id,who,bug_when would also work.  That's not as
>'neat and clean' to store for my purposes, but if that's the official
>answer I'll go with it.
><snip>
>

I'd prefer #2.   That will also help with people who use M$ACCESS to 
front-end the DB for special reports while preserving my right to make 
multiple comments to the same bug within the same second.  That key 
could even turn out to be useful eventually.

-Joel







More information about the developers mailing list