Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed
Дата
Msg-id 4B6A1CB9.8060100@hogranch.com
обсуждение исходный текст
Ответ на Need to Remove Constraint, but Don't Know How - Previous attempts failed  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
Список pgsql-general
Wang, Mary Y wrote:
> Hi,
>
> I'm sorry but I didn't create the table.  I fiddled with the table for a while and didn't get what I expected.  So
I'mgoing to ask the community. 
>
> Can some one tell me which constraint would case me the "duplicate key into unique index users_pkey"?  I'd like to
removethat constraint. 
>

I only see one constraint on that table, the primary key.

your table's primary key, named users_pkey,  is on user_id.  you want to
have duplicate user_id values in your table ?









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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Is it necessary to have index for child table in following case?