Re: Database Error (Bogus atrribute number 24....)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steven Tower <tower(at)towerhome(dot)cx>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Error (Bogus atrribute number 24....)
Date: 2003-11-08 16:05:32
Message-ID: 7115.1068307532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steven Tower <tower(at)towerhome(dot)cx> writes:
> I am receiving the following error from Postgres 7.3.3 on Linux
> Bogus attribute number 24 for vs_actfreighservices (a view).

Hm, can you tell us how you got into this fix? That shouldn't happen
AFAICS.

As far as getting out of the problem is concerned, if you don't need the
view you could just manually delete its pg_class row: as superuser do

delete from pg_class where relname = 'vs_actfreighservices'

(if you have multiple views named vs_actfreighservices in different
schemas, more selectivity would be needed). That should leave you in a
state where you can run pg_dump.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-08 17:54:23 Re: Postgres Web Page
Previous Message Steven Tower 2003-11-08 14:49:54 Database Error (Bogus atrribute number 24....)