Bug ID domain?

Bradley Baetz bbaetz at acm.org
Fri Apr 25 07:41:46 UTC 2003

On Fri, Apr 25, 2003 at 03:23:27AM -0400, Jason Pyeron wrote:
> On Fri, 25 Apr 2003, Bradley Baetz wrote:
> >Hmm. Maybe putting it into the data table will work. You'd have to use
> >NULL (not 0, or anything else) so that FKs will work. (Besides, NULL is
> >the 'correct' thing here)
> >
> Yes that is right but he has it set such that the pk is (null,val) that is 
> why he said they could not be used and was looking for a hack.

Ah, right, I missed that.

> What needs to be done is:
> do a unique index on (null,val) and have an ID pk not null column.

Well, you don't need a PK. Have the field id be non-null, and add unique
constraint on (bug, field).

Think about the 'multiple' bit - there is no PK there since (bug, field)
isn't unique.


More information about the developers mailing list