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 19:30:31
Message-ID: 20030716.672.26066200@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
lang_pkey

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dmitry Tkach 2003-07-16 19:45:34 Re: Cannot insert a duplicate key into unique index
Previous Message Tom Lane 2003-07-16 14:40:21 Re: Problem with psql interface