Re: [Lxr-dev] New database structure about to land

[Arne G. G. <ar...@li...>]

* Malcolm Box
> indexes.type is still indexes.type, but it now references
> declarations.declid.  indexes.langid references declarations.langid. 
> Non-normalised I know - see the bug report ;-)

Ah, like so.  But if langid is a functional dependency of declid,
couldn't you just make declid the primary key of declarations and be
done with it?  You could even remove langid from the indexes table,
possibly with a significant size gain.

Anyway, I still think I'm right.  d.declid in Kristoffer's Postgres.pm
patch (in the setting of $indexes_select) should be d.declaration as
far as I'm able to see.  That's the way it looks in Mysql.pm, at least.


							Arne.