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

From John R Pierce
Subject Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed
Date
Msg-id 4B6A1CB9.8060100@hogranch.com
Whole thread Raw
In response to Need to Remove Constraint, but Don't Know How - Previous attempts failed  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed
Next
From: Joe Conway
Date:
Subject: Re: Is it necessary to have index for child table in following case?