Home > mailing lists

What causes a table's oid to change? - Mailing list pgsql-novice

From	Richard Ray
Subject	What causes a table's oid to change?
Date	October 8, 2002 20:38:50
Msg-id	200210082137.g98LbTs04843@e3000b.state.ms.us Whole thread Raw
Responses	Re: What causes a table's oid to change? (Josh Berkus <josh@agliodbs.com>)
List	pgsql-novice

Tree view

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 by date:

From: Giles Lean
Date: 08 October 2002, 20:30:52
Subject: Re: hiding normalization with views

From: Josh Berkus
Date: 08 October 2002, 21:59:24
Subject: Re: What causes a table's oid to change?

What causes a table's oid to change? - Mailing list pgsql-novice

Previous

Next