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

Crete not autoincremented integer prymary key #351

Closed vikingUnet closed 3 years ago

vikingUnet commented 3 years ago

Hello! How to create primary key integer without increment=True in Postgres? When you set primary key column type in [integer, bigint], it is automatic transform to autoincrement types serial and bigserial. My sadness solution is to create smallint column type and after change type of column with alter DDL to old type integer or bigint. Any idea for standart solution to situations like this? Thanks!