Two entries with the same primary key

From: Ivan Evtuhovich <evtuhovich(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Two entries with the same primary key
Date: 2012-04-12 14:20:20
Message-ID: CAOXtjwcmzA0ocGM1x7mPxeCUcqjQ_ggZE9JcFLDm5GLbSin-sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

More then month ago we upgrade DB from 9.0 to 9.1 with pg_upgrade. Then we
move DB to another server with standard pg streaming replication.

Now we have two entries with the same primary key. And I do not know what
to do.

SELECT ctid, id from billing_invoices where id = 27362891;
ctid | id
--------------+----------
(1112690,11) | 27362891
(1112438,26) | 27362891

\d billing_invoices
Table "public.billing_invoices"
Column | Type |
Modifiers
----------------+-----------------------------+---------------------------------------------------------------
id | integer | not null default
nextval('billing_invoices_id_seq'::regclass)
...
created_at | timestamp without time zone |
updated_at | timestamp without time zone |
Indexes:
"billing_invoices_pkey" PRIMARY KEY, btree (id)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Welty, Richard 2012-04-12 14:57:54 recommended schema diff tools?
Previous Message Tom Lane 2012-04-12 13:55:58 Re: non-static LIKE patterns