Postgres Pro
Downloads
Home   >   mailing lists

Cannot insert a duplicate key into unique index - Mailing list pgsql-novice

From Brian Johnson
Subject Cannot insert a duplicate key into unique index
Date
Msg-id 20030716.672.26066200@192.168.0.1
Whole thread Raw
Responses Re: Cannot insert a duplicate key into unique index  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with psql interface
Next
From: Dmitry Tkach
Date:
Subject: Re: Cannot insert a duplicate key into unique index