| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | comanicibogdy(at)yahoo(dot)com |
| Subject: | BUG #17892: Bug primary key |
| Date: | 2023-04-12 10:30:10 |
| Message-ID: | 17892-ac3a507a8e97a453@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17892
Logged by: Comanici Bogdan
Email address: comanicibogdy(at)yahoo(dot)com
PostgreSQL version: 13.9
Operating system: Debian 11
Description:
We have a database with over 3 milions apps in it
Something happend we just found duplicates with same id, but we have
constraints : PRIMARY KEY on id
How it's happened?
ID(PRIMARY KEY) SLUG(UNIQUE KEY)
29181513 nottiled 0 Home-and-Hobby Recreation mirwanda-center false 0 false false false true false 2019-07-15
11:53:38.000 2023-04-10
21:44:34.000 0.0 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NotTiled 0 0.00 1.8.6 Freeware 0.0 2022-09-19 adsense true 0 2 false
29181513 nottiled 0 Home-and-Hobby Recreation mirwanda-center false 0 false false false true false 2019-07-15
11:53:38.000 2023-03-25
14:32:55.000 0.0 0.0 0 26 0 1 0 26 0 0 5 0 0 0 5 0 0 NotTiled 22020096 0.00 1.7.0a Freeware 0.0 2021-09-03 adsense true 20230410 2 false
We tried manually to insert a new row with same value, get error for unique
key slug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2023-04-12 12:00:01 | BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact |
| Previous Message | David Rowley | 2023-04-12 09:05:55 | Re: BUG #17862: Overall query cost ignores window function |