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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com>
Cc: Mike Mascari <mascarm(at)mascari(dot)com>, pg-gen <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)
Date: 1999-12-23 02:13:22
Message-ID: 199912230213.VAA09313@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Henderson 1999-12-23 05:58:16 shared memory - progress
Previous Message Ed Loehr 1999-12-23 01:56:54 Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)