PostgreSQL Administration - pg_dump: schema with OID xxxxxxxx does not exist

Author

pg_dump: schema with OID xxxxxxxx does not exist

Peter Neish

2006-10-27, 5:14 am

Running pg_dump gives this error:
pg_dump: schema with OID 37647910 does not exist

I've found a variation of this on the mailing list, but I'm not entirely
sure what to do about it.

I found this OID by running: select * from pg_type where typnamespace =
37647910;

and two entries:

typname | typnamespace | typowner | typlen | typbyval |
typtype | typisdefined | typdelim | typrelid | typelem | typinput |
typoutput | typreceive | typsend | typalign | typstorage |
typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault
-----------------------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+-----------+------------+-------------+-------------+----------+------------+------------+-------------+-----------+----------+-
--------------+------------
entity_browse_bid_se
q | 37647910 | 1005 | 4 | t |
c | t | , | 37894096 | 0 | record_in |
record_out | record_recv | record_send | i | p |
f | 0 | -1 | 0 | |
entity_browse | 37647910 | 1005 | 4 | t |
c | t | , | 37894098 | 0 | record_in |
record_out | record_recv | record_send | i | p |
f | 0 | -1 | 0 | |
(2 rows)

Does this mean that I can just delete these rows from this table for the
dump to work? Will deleting these rows affect anything else? Can you
tell that I'm not really sure what I am doing - I just need to get a
database from one server to another.

Thanks for any help you could give me,

Peter

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Tom Lane

2006-10-27, 7:46 pm

Peter Neish <peter@austehc.unimelb.edu.au> writes:
> entity_browse_bid_se
q | 37647910 | 1005 | 4 | t |
> c | t | , | 37894096 | 0 | record_in |
> record_out | record_recv | record_send | i | p |
> f | 0 | -1 | 0 | |
> entity_browse | 37647910 | 1005 | 4 | t |
> c | t | , | 37894098 | 0 | record_in |
> record_out | record_recv | record_send | i | p |
> f | 0 | -1 | 0 | |
> (2 rows)

> Does this mean that I can just delete these rows from this table for the
> dump to work? Will deleting these rows affect anything else?

These are composite-type entries, which means there should be
associated entries in pg_class --- with OIDs 37894096 and 37894098
respectively. Did you check to see if those are still there?

We've seen scattered reports of table rowtype entries not being removed
when the owning table is dropped, but no one's ever been able to make a
reproducible case :-(. Do you know anything about the history or usage
of these tables?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links