Обсуждение: Unusual PK contraint error

Поиск

Список

Период

Сортировка

Unusual PK contraint error

От

"Jasbinder Singh Bali"

Дата:

31 марта 2007 г., 15:46:24

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

Re: Unusual PK contraint error

От

Tom Lane

Дата:

31 марта 2007 г., 16:13:17

"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> DBD::Pg::st execute failed: ERROR:  duplicate key violates unique constraint
> "pk_verify_mx"
> I don't know whats goin on.

Corrupt index maybe?  Does REINDEXing the pk index help?

            regards, tom lane

Re: Unusual PK contraint error

От

"Jasbinder Singh Bali"

Дата:

31 марта 2007 г., 17:45:55

how do u do reindexing?

On 3/31/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> DBD::Pg::st execute failed: ERROR:  duplicate key violates unique constraint
> "pk_verify_mx"
> I don't know whats goin on.

Corrupt index maybe?  Does REINDEXing the pk index help?

                        regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Unusual PK contraint error

Unusual PK contraint error

Re: Unusual PK contraint error

Re: Unusual PK contraint error