Home > mailing lists

Re: Table with seemingly duplicated primary key values - Mailing list pgsql-general

From	Melvin Davidson
Subject	Re: Table with seemingly duplicated primary key values
Date	December 22, 2015 19:32:15
Msg-id	CANu8FiyFMNWuU=Y6uZbtDr591ytMfqfVzjjoi_tU1u4nQAN4AA@mail.gmail.com Whole thread Raw
In response to	Re: Table with seemingly duplicated primary key values (Aleksander Łukasz <allllllx@gmail.com>)
Responses	Re: Table with seemingly duplicated primary key values
List	pgsql-general

The fact that you have rows with an identical id of 2141750 verifies a corrupted primary index.

To correct it, you need to decide which row to keep.

So review the results of

SELECT * FROM some_table WHERE ctid = (79664,59) OR ctid = (79772,23)

DELETE FROM some_table
WHERE id = 2147150
AND field1 = {value for field1 of row to delete}

AND field2 = {value for field2 of row to delete}
...
...

AND fieldn = {value for fieldn of row to delete};

Then
REINDEX TABLE some_table;

From: oleg yusim
Date: 22 December 2015, 18:50:01
Subject: Re: Session Identifiers

From: oleg yusim
Date: 22 December 2015, 22:52:29
Subject: Shared system resources