Re: [sqlalchemy] Primary keys mandatory sortability

2019-06-24 Thread Nico C.
One of the many reasons not to implement __lt__, is that the types are used with different databases. Those have had very different stories, especially enum labels may not have been added in the same order. Hence, defining and order may lead people to rely on it. But, on either side (postgresql

[sqlalchemy] Primaire keys mandatory sortability

2019-06-24 Thread Nico C.
Hi there, Where I work, in our data model, we'd have several the opportunity to have primary keys defined has a composite of something + an enum value. Though because sqlalchemy requises that primary keys can be sorted, it is not possible to define such primary keys. Indeed, in Python, enums

Re: [sqlalchemy] Re: exception message encoded in utf8

2018-01-18 Thread Nico C.
I think I can help reproduce this, but one has to configure the base system in a non C or english locale. E.g. the system I work with is in french: it's default locale is fr_FR.UTF-8, hence the postgresql server I installed on it runs with that locale too, by default. One can check with the