Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17135: duplicate key value violates unique constraint - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17135: duplicate key value violates unique constraint
Date
Msg-id CAKFQuwa9PwJdFjRaW=oF7K6-XNg8Q6Tf20rxaqsK-wQPoBPwTw@mail.gmail.com
Whole thread Raw
In response to BUG #17135: duplicate key value violates unique constraint  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17135: duplicate key value violates unique constraint
Next
From: Tom Lane
Date:
Subject: Re: Can not cancel a call to a function that has opened a refcursor