Re: Table's OID

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: papapep <papapep(at)gmx(dot)net>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Table's OID
Date: 2003-12-15 16:12:53
Message-ID: 12989.1071504773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

papapep <papapep(at)gmx(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-12-15 16:14:58 Re: Headr files
Previous Message Sai Hertz And Control Systems 2003-12-15 15:46:40 WITH OIDS tables gives problem