Thanks Ilja

Im on MYSQL

Bien à vous

Jacques Beaudoin

Selon Ilja Booij <[EMAIL PROTECTED]>:

> 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
>
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

Reply via email to