Re: Table's OID

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