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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need to Remove Constraint, but Don't Know How - Previous attempts failed
Date: 2010-02-04 01:02:49
Message-ID: 4B6A1CB9.8060100@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'm going 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 remove that 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 ?

In response to

Browse pgsql-general by date

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