Re: Table with seemingly duplicated primary key values

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Aleksander Łukasz <allllllx(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table with seemingly duplicated primary key values
Date: 2015-12-22 19:31:26
Message-ID: CANu8FiyFMNWuU=Y6uZbtDr591ytMfqfVzjjoi_tU1u4nQAN4AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message oleg yusim 2015-12-22 22:52:23 Shared system resources
Previous Message oleg yusim 2015-12-22 18:49:55 Re: Session Identifiers