Re: Table's OID

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Table's OID
Дата
Msg-id 12989.1071504773@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Table's OID  (papapep <papapep@gmx.net>)
Ответы Re: [personal] Re: Table's OID
Список 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 по дате отправления:

Предыдущее
От: Sai Hertz And Control Systems
Дата:
Сообщение: WITH OIDS tables gives problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Headr files