Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #17135: duplicate key value violates unique constraint

BUG #17135: duplicate key value violates unique constraint

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      17135
Logged by:          Jaineel Chauhan
Email address:      jaineelrc141199@gmail.com
PostgreSQL version: 12.6
Operating system:   ubuntu 20.04
Description:

Please give solution for below problem ::

duplicate key value violates unique constraint "mail_followers_pkey"
DETAIL:  Key (id)=(1490) already exists.

Re: BUG #17135: duplicate key value violates unique constraint

From
"David G. Johnston"
Date:
On Thu, Aug 5, 2021 at 7:24 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17135
Logged by:          Jaineel Chauhan
Email address:      jaineelrc141199@gmail.com
PostgreSQL version: 12.6
Operating system:   ubuntu 20.04
Description:       

Please give solution for below problem ::

duplicate key value violates unique constraint "mail_followers_pkey"
DETAIL:  Key (id)=(1490) already exists.


DELETE FROM mail_followers WHERE id = 1490;

The above will probably work...but it also probably isn't something you should consider seriously.  But it's the best I can come up with giving the fact you've provided zero context about how/where/when this error is occuring.

David J.