Re: FK Constraint on index not PK - Mailing list pgsql-general

From Stéphane Schildknecht
Subject Re: FK Constraint on index not PK
Date
Msg-id 45A88FCA.1070606@postgresqlfr.org
Whole thread Raw
In response to Re: FK Constraint on index not PK  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: FK Constraint on index not PK  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Joshua D. Drake a écrit :
> On Fri, 2007-01-12 at 17:50 +0100, Stéphane Schildknecht wrote:
>
>> Dear community members,
>>
>> I'm having a quite strange behaviour while trying to drop some index.
>>
>> We have some tables with two indexes on a primary key. The first one was
>> automatically created by the primary constraint. The second one was
>> manually created on the same column. Don't know why, but I would now
>> want to suppress it.
>>
>
> Drop the second index. It is redundant.
>

I know it. But I can't.

SAS

pgsql-general by date:

Previous
From: Stéphane Schildknecht
Date:
Subject: Re: FK Constraint on index not PK
Next
From: Shane Ambler
Date:
Subject: Re: PostgreSQL Connections?