Re: Database Error (Bogus atrribute number 24....) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database Error (Bogus atrribute number 24....)
Date
Msg-id 7115.1068307532@sss.pgh.pa.us
Whole thread Raw
In response to Database Error (Bogus atrribute number 24....)  (Steven Tower <tower@towerhome.cx>)
Responses Re: Database Error (Bogus atrribute number 24....)
Re: Database Error (Bogus atrribute number 24....)
List pgsql-admin
Steven Tower <tower@towerhome.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

pgsql-admin by date:

Previous
From: Steven Tower
Date:
Subject: Database Error (Bogus atrribute number 24....)
Next
From: Juan Miguel
Date:
Subject: Re: Postgres Web Page