Re: Table's OID - Mailing list pgsql-novice

From Tom Lane
Subject Re: Table's OID
Date
Msg-id 12989.1071504773@sss.pgh.pa.us
Whole thread Raw
In response to Table's OID  (papapep <papapep@gmx.net>)
Responses Re: [personal] Re: Table's OID
List pgsql-novice
papapep <papapep@gmx.net> writes:
> How can I modify a table OID? I deleted and recreated a table and now
> when I try to run my reports (with Cognos Impromptu) it says:

> | ERROR:  Relation "control_flota" with OID 36775365 no longer exists

You probably need to recreate some view that refers to that table.

BTW, if you were running PG 7.3 or 7.4, it'd not have let you get into
this position.  Think about updating ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: WITH OIDS tables gives problem
Next
From: Tom Lane
Date:
Subject: Re: Headr files