Support for multiple "Locations" in bugzilla

Bradley Baetz bbaetz at acm.org
Fri Feb 28 22:22:05 UTC 2003


On Fri, Feb 28, 2003 at 09:53:56PM +0000, Gervase Markham wrote:
> 
> But, I was rather hoping that bbaetz, as our database guru, would lay 
> down the law about the right way to do this.

'database guru'? :)

Anyway, I thought I'd mentioned the correct idea several times before.
Use mapping tables. This (or any other solution, really) requires most
of the fielddefs table hacks, such as the mailhead column, to be
removed.

The extra joins are very unlikly to be noticed except in buglist.cgi,
and it may be possible to only do that join once, although I'd have to
think about it.

Hows postgres support coming along? :)

> 
> Gerv
> 

Bradley



More information about the developers mailing list