On Thu, 2004-04-29 at 16:28, Jacques Beaudoin wrote: > Hi Ilja > > I will be installing 1.2.7a > > Sory i dont know what a "UNIQUE constraint" is !!! > > Should i do anything to my tables > to correct that "UNIQUE constraint" > before or after i install 1.2.7a
If you're on PostgreSQL it's easiest to do: DROP INDEX aliases_alias_idx; DROP INDEX aliases_alias_low_idx; CREATE INDEX aliases_alias_idx ON aliases(alias); CREATE INDEX aliases_alias_low_idx ON aliases(lower(alias)); If you're on MySQL, you don't have to change anything. After that everything should work just fine. Ilja
