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)
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 |