The whole idea around unique_keys=["col"] doesn't work for buffered rows. Since not all modifications are committed directly to the database, this make the unique constraint working unreliably.
To make it work, you have to commit transactions manually after each modification.
The whole idea around
unique_keys=["col"]doesn't work for buffered rows. Since not all modifications are committed directly to the database, this make the unique constraint working unreliably.To make it work, you have to commit transactions manually after each modification.