Unusual PK contraint error
Hi
I have a compostie primary key in my table comprising of 3 fields.
My systems tries to enter records in this table for which the combination of
these 3 fields is not there at all
The new record gets inserted but with the following error being displayed on
console
DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint
"pk_verify_mx"
I don't know whats goin on. Records get inserted but this duplicate key
error is being thrown
~Jas
"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
how do u do reindexing?
Show quoted text
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