Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Unusual PK contraint error
- From: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Unusual PK contraint error
- Date: Sat, 31 Mar 2007 14:46:18 -0400
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
- Follow-Ups:
- Re: Unusual PK contraint error
- From: Tom Lane
- Re: Unusual PK contraint error
- Prev by Date: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
- Next by Date: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
- Previous by thread: Instalation problem
- Next by thread: Re: Unusual PK contraint error
- Indexes: