RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Matthew" <matt(at)ctlno(dot)com>
Cc: "'Mikheev, Vadim'" <vmikheev(at)SECTORBASE(dot)COM>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!
Date: 2001-03-23 22:56:17
Message-ID: EKEJJICOHDIEMGPNIFIJIEBFDPAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Matthew
>
> > > The vacuum I tried in single user mode failed (froze on a
> > > table, for over 20 minutes) so I killed it.
> >
> > Did you destroy indices before vacuum?
> >
> Not all of them, it's a large database and I am trying to get it up
> and running asap.
>
> FYI now when I try to use psql to connect to the database I get this
> error:
>
> bash$ psql cms
> psql: FATAL 1: cannot find attribute 1 of relation pg_trigger
>

Please try the following query under standalone postgres(with -P and -O
options).

select * from pg_attribute where attrelid=1219 and attnum=1;

If you would get no result, your pg_attribute is corrupted unfortunately.

regards,
Hiroshi Inoue

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2001-03-23 22:58:56 Re: odbc/UnixWare 7.1.1: No Go.
Previous Message Tom Lane 2001-03-23 20:08:27 Re: Re: Call for platforms