Cannot insert a duplicate key into unique index

Поиск
Список
Период
Сортировка
От Brian Johnson
Тема Cannot insert a duplicate key into unique index
Дата
Msg-id 20030716.672.26066200@192.168.0.1
обсуждение исходный текст
Ответы Re: Cannot insert a duplicate key into unique index  (Dmitry Tkach <dmitry@openratings.com>)
Список 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?


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with psql interface
Следующее
От: Dmitry Tkach
Дата:
Сообщение: Re: Cannot insert a duplicate key into unique index