Re: FK Constraint on index not PK
От | Joshua D. Drake |
---|---|
Тема | Re: FK Constraint on index not PK |
Дата | |
Msg-id | 1168624645.9512.16.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | FK Constraint on index not PK (Stéphane Schildknecht<stephane.schildknecht@postgresqlfr.org>) |
Ответы |
Re: FK Constraint on index not PK
|
Список | pgsql-general |
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. Joshua D. Drake > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-general по дате отправления: