pg_dump: schema with OID xxxxxxxx does not exist
От | Peter Neish |
---|---|
Тема | pg_dump: schema with OID xxxxxxxx does not exist |
Дата | |
Msg-id | 45418477.2020400@austehc.unimelb.edu.au обсуждение исходный текст |
Ответы |
Re: pg_dump: schema with OID xxxxxxxx does not exist
|
Список | pgsql-admin |
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_seq | 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
В списке pgsql-admin по дате отправления: