Duplicate rows with primary key constraint in PostgreSQL 10.6

1 vote

1 answer

1047 views

postgresql primary-key postgresql-10 duplication debugging

                          I have a table that's had CONSTRAINT table_pkey PRIMARY KEY (id) since setup.

However, I recently found that I have around 100 duplicate rows (I ran select count(*) from (select count(*) from table group by id having count(*) > 1) as t1 as per this old stack post . However, I'm running Postgres 10.6, which should be far after that bug.  
Any ideas?
                        

Asked by mckennab (111 rep)

Jul 3, 2019, 11:33 PM
Last activity: Apr 18, 2025, 04:05 AM

Duplicate rows with primary key constraint in PostgreSQL 10.6

Related Questions