UNIQUE on postgres not working on empty values
I am running postgres 8.3, which seems not to take in account empty values on composed UNIQUE constraints. So it is currently possible with UNIQUE(name, parent) to create party categories of the same name if they don't have a parent.
How to handle this in general? Should tryton insert 0 for an integer resp. '' for a string to have working UNIQUE on empty values?