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
Список
Дерево обсуждения
What causes a table's oid to change? Richard Ray <rray1@netdoor.com>
Re: What causes a table's oid to change? Josh Berkus <josh@agliodbs.com>
Re: What causes a table's oid to change? Tom Lane <tgl@sss.pgh.pa.us>
Re: What causes a table's oid to change? "Josh Berkus" <josh@agliodbs.com>
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
Дата:
От: Josh Berkus
Дата:
FAQ