Re: [GENERAL] Unusual PK contraint error

2007-03-31 Thread Jasbinder Singh Bali
how do u do reindexing? On 3/31/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Jasbinder Singh Bali" <[EMAIL PROTECTED]> 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

Re: [GENERAL] Unusual PK contraint error

2007-03-31 Thread Tom Lane
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> 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

[GENERAL] Unusual PK contraint error

2007-03-31 Thread Jasbinder Singh Bali
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: