Re: FK Constraint on index not PK

From: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: FK Constraint on index not PK
Date: 2007-01-13 07:52:42
Message-ID: 45A88FCA.1070606@postgresqlfr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcel Gsteiger 2007-01-13 08:33:46 Problems with unique restrictions
Previous Message Stéphane Schildknecht 2007-01-13 07:52:06 Re: FK Constraint on index not PK