Re: ERROR: cannot find attribute 1 of relation pg_temp

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Vladimir Sakhovsky <sakhovsky(at)gmd(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: cannot find attribute 1 of relation pg_temp
Date: 2000-12-09 23:12:22
Message-ID: 200012092312.SAA01682@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Looks like a temp table that lost it's pg_attribute entry. Try dropping
pg_temp.13435 and see if that helps.

> Hi,
>
> When I vacuuming database I'm getting this error:
>
> $vacuumdb --analyze mydatabase
>
> ERROR: cannot find attribute 1 of relation pg_temp.13435.0
> vacuumdb: database vacuum failed on mydatabase
>
> How this can be fixed?
>
> I'm running on RadHat 6.2, Postgresql-6.5.3-6.
>
> Any help would be appreciated,
>
> Vladimir Sakhovsky
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rynell Wesson 2000-12-10 03:42:09 Function overloading
Previous Message Lockhurst 2000-12-09 09:31:18 Re: Which Linux Distribution