pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: comanicibogdy@yahoo.com
Subject: BUG #17892: Bug primary key
Date: Wed, 12 Apr 2023 10:30:10 +0000
Message-ID: <17892-ac3a507a8e97a453@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      17892
Logged by:          Comanici Bogdan
Email address:      comanicibogdy@yahoo.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



view thread (5+ messages)  latest in thread

Message-ID: <17892-ac3a507a8e97a453@postgresql.org>
Permalink:  ../17892-ac3a507a8e97a453@postgresql.org/
Also on:    postgresql.org/message-id/17892-ac3a507a8e97a453@postgresql.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, comanicibogdy@yahoo.com
  Subject: Re: BUG #17892: Bug primary key
  In-Reply-To: <17892-ac3a507a8e97a453@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox