Search Postgresql Archives
Unusual PK contraint error
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: Unusual PK contraint error
- From: "Jasbinder Singh Bali" <jsbali@xxxxxxxxx>
- Date: Sat, 31 Mar 2007 14:46:18 -0400
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=I/UerkCFQOsU5ExZE5bdLO7JKhqre/TpEkLAmORPA/rc5Kfp66xhxUxj8bV9qjYq8F7n2TGnh3MmuyOGbXraASvaFf8M+e2omMiLtgMtUfkrauEsO5vdkYPzIWa1AYhO+DxvEtgxAUqMJ4HVYEfNrnUvxVcPjnxV2cykjvtbzpg=
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]