Postgres Pro
Downloads
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
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  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view
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;

​

pgsql-general by date:

Previous
From: oleg yusim
Date:
Subject: Re: Session Identifiers
Next
From: oleg yusim
Date:
Subject: Shared system resources