pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
https://dataset.readthedocs.org/
MIT License
4.76k stars 297 forks source link

UPSERT_MANY creates another index #382

Closed ohld closed 2 years ago

ohld commented 2 years ago

Hey!

I have a table with uuid as a Primary key (see my screenshot with my table's indexes). I want to upsert_many(items, keys=["uuid"]) to this table. In result, another index on the same column uuid is created by dataset.

I expect that dataset should use already existed Primary Key Index instead of creating another one which is basically the same.

image