Re: [GENERAL] FK Constraint on index not PK

2007-01-14 Thread Stéphane Schildknecht
Tom Lane a écrit : > =?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?= <[EMAIL PROTECTED]> writes: > >> My goal is to migrate to 8.2.1. definitely. But as you said it, I do not >> want to recreate unwanted index when migrating. I want to drop them BEFORE. >> But, I can't just do a "drop index" comman

Re: [GENERAL] FK Constraint on index not PK

2007-01-13 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > The problem is that the constraint was defined with a dependence on the > second index. I guess what you could do is drop the constraint, drop > the second index, and then recreate the constraint. Try it within a > transaction block, just in case it do

Re: [GENERAL] FK Constraint on index not PK

2007-01-13 Thread Tom Lane
=?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?= <[EMAIL PROTECTED]> writes: > My goal is to migrate to 8.2.1. definitely. But as you said it, I do not > want to recreate unwanted index when migrating. I want to drop them BEFORE. > But, I can't just do a "drop index" command. It fails. Right, because

Re: [GENERAL] FK Constraint on index not PK

2007-01-13 Thread Alvaro Herrera
Stéphane Schildknecht wrote: > 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 primar

Re: [GENERAL] FK Constraint on index not PK

2007-01-13 Thread Richard Huxton
Stéphane Schildknecht wrote: My goal is to migrate to 8.2.1. definitely. But as you said it, I do not want to recreate unwanted index when migrating. I want to drop them BEFORE. But, I can't just do a "drop index" command. It fails. That's why I asked for an advice to drop them or not recreate

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Stéphane Schildknecht
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 cre

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Stéphane Schildknecht
Scott Marlowe a écrit : > Being quite familiar with both of those issues from the past, I can't > imagine either one causing a problem with an update prior to dumping so > he can then upgrade to 8.2. > > Seriously. Hungarian collation, plerl can no longer change locale and > corrupt indexes, and a

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Scott Marlowe
gineer > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe > Sent: Friday, January 12, 2007 12:59 PM > To: Stéphane Schildknecht > Cc: pgsql general > Subject: Re: [GENERAL] FK Constraint on index not PK > > On Fri

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Brandon Aiken
ry 12, 2007 12:59 PM To: Stéphane Schildknecht Cc: pgsql general Subject: Re: [GENERAL] FK Constraint on index not PK On Fri, 2007-01-12 at 10:50, Stéphane Schildknecht wrote: > Dear community members, > > I'm having a quite strange behaviour while trying to drop some index. >

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Scott Marlowe
On Fri, 2007-01-12 at 10:50, 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

Re: [GENERAL] FK Constraint on index not PK

2007-01-12 Thread Joshua D. Drake
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 s