Re: FK Constraint on index not PK

Поиск
Список
Период
Сортировка
От Stéphane Schildknecht
Тема Re: FK Constraint on index not PK
Дата
Msg-id 45A88FCA.1070606@postgresqlfr.org
обсуждение исходный текст
Ответ на Re: FK Constraint on index not PK  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: FK Constraint on index not PK  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Stéphane Schildknecht
Дата:
Сообщение: Re: FK Constraint on index not PK
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: PostgreSQL Connections?