What causes a table's oid to change?

Поиск
Список
Период
Сортировка
От Richard Ray
Тема What causes a table's oid to change?
Дата
Msg-id 200210082137.g98LbTs04843@e3000b.state.ms.us
обсуждение исходный текст
Ответы Re: What causes a table's oid to change?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
I have a table with many views. I did something to cause the table to change
oid. I don't know what I did. When I try to access the data using one of
these views I get "ERROR:  Relation "documents" with OID 24389201 no longer
exists". The table is fine. If I drop the view and recreate it it works fine.
Can you tell me some of the common thing that would cause this? Can I "reset"
the oid?

Thanks
Richard

В списке pgsql-novice по дате отправления:

Предыдущее
От: Giles Lean
Дата:
Сообщение: Re: hiding normalization with views
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: What causes a table's oid to change?