Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)
Date
Msg-id 199912230213.VAA09313@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)  (Ed Loehr <ELOEHR@austin.rr.com>)
List pgsql-general
> Bruce Momjian wrote:
>
> > > > > > > Anyone seen this message or know what it means?
> > > > > > >
> > > > > > > NOTICE:  Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071) IS
> > > > > > > NOT THE SAME AS HEAP' (1070)
> > > > > >
> >
> > The only way to fix that is to initdb, I think.  I would recommend
> > pg_upgrade, after removing the disable from the pg_upgrade script that
> > was added in 6.5.  That will fix it.  Not sure how it got that way,
> > though.
>
> El dope primero aqui...
>
> Thanks for the tip.  Here's what I had to do to make this work, for what it's worth
> to future travelers...

Glad to see pg_upgrade fixed you.



--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)
Next
From: "John Henderson"
Date:
Subject: shared memory - progress