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