SQLAlchemy: how to make primary_key not unique (PostgreSQL)?

Question

I really need that. I've tried to define it in my model:

vs_id = Column(Integer, primary_key=True, unique=False)

But it didn't work - database schema has such row:

ALTER TABLE ONLY my_table__ ADD CONSTRAINT my_table___pkey PRIMARY KEY (vs_id);

How to solve this? Thanks in advance!

Primary key is by definition something that uniquely identifies rows. — newtover
– newtover, Commented Mar 10, 2012 at 18:23
And if you're trying to make it a primary key for the purpose of fast lookups consider using an index instead. — aquavitae
– aquavitae, Commented Mar 10, 2012 at 19:39

lnafziger · Accepted Answer · 2012-03-10 18:29:27Z

3

The primary key MUST be unique, in order to be able to refer to a specific record.

If you need this, add another field that isn't unique!

answered Mar 10, 2012 at 18:29

lnafziger

25.7k8 gold badges64 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1