Postgres Pro
Downloads
Home   >   mailing lists

Re: Unusual PK contraint error - Mailing list pgsql-general

From Jasbinder Singh Bali
Subject Re: Unusual PK contraint error
Date
Msg-id a47902760703311345h361a2363x4cbb45d5731ecc94@mail.gmail.com
Whole thread Raw
In response to Re: Unusual PK contraint error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
how do u do reindexing?

On 3/31/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> DBD::Pg::st execute failed: ERROR:  duplicate key violates unique constraint
> "pk_verify_mx"
> I don't know whats goin on.

Corrupt index maybe?  Does REINDEXing the pk index help?

                        regards, tom lane

pgsql-general by date:

Previous
From: "Eric B. Ridge"
Date:
Subject: VACUUM FULL takes long time to complete
Next
From: "Harpreet Dhaliwal"
Date:
Subject: introduction of FK results in no data insert