Skip site navigation (1) Skip section navigation (2)

Cannot insert a duplicate key into unique index?

From: "Brian Johnson" <bjohnson(at)johnson-engineering(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cannot insert a duplicate key into unique index?
Date: 2003-07-16 12:22:36
Message-ID: 20030716.1nE.51550700@ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I keep getting this error from a complex, multi-table php app

postgres[4513]: [4] ERROR:  Cannot insert a duplicate key into unique index

To help me find the problem, is there a way to get logging to show what table the
error is caused by or what SQL code is causing it?

Also, from researching this problem on the internet, it look slike the unique index
would normally have three segments table_field_key .. any idea why this one is
listed differently?

pgsql-novice by date

Next:From: Tom LaneDate: 2003-07-16 14:40:21
Subject: Re: Problem with psql interface
Previous:From: paul butlerDate: 2003-07-16 06:24:09
Subject: Re: Anyone used

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group