* Betr.: " [tryton-dev] Bring some attention on issue1422" (Fri, 2 Apr 2010 11:10:06 +0200):
> There is a possible solution that will work only for PostgreSQL:
>
> CREATE UNIQUE INDEX "index" ON "table" ("name", COALESCE("parent", 0));
>
> Is there anybody who has better solution?
>
>
> [1] http://bugs.tryton.org/roundup/issue1422
Since it seems, that this issue has to be solved indivdually per DBMS and we
don't want to provide our own logical layer, this is the way to go for me.
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
http://bytes.com/topic/oracle/answers/65985-unique-constraint-null-values
--
Mathias Behrle
MBSolutions
Gilgenmatten 10 A
D-79114 Freiburg
Tel: +49(761)471023
Fax: +49(761)4770816
http://mbsolutions.selfip.biz
UStIdNr: DE 142009020
PGP/GnuPG key availabable from any keyserver, ID: 0x89BCA161
signature.asc
Description: PGP signature
