pg_dump: schema with OID 145167 does not exist

Поиск
Список
Период
Сортировка
От Paul Wouters
Тема pg_dump: schema with OID 145167 does not exist
Дата
Msg-id 000001cd0776$9b20b600$d1622200$@wouters@resilion.be
обсуждение исходный текст
Список pgsql-admin

Hello,

 

We have some problems using pg_dump. We get the following error:

pg_dump: schema with OID 145167 does not exist

 

I found one entry in the pg_type and another one in the pg_class.

I was able to remove the one in the pg_class but when we try to remove the row in the pg_type, I get an error:

Error: Invalid input syntax for type oid: “record_in”

 

select * from pg_type where typnamespace = 145167;

     typname     | typnamespace | typowner | typlen | typbyval | typtype | typisdefined | typdelim | typrelid | typelem | typinput  | typoutput  | typreceive  |   typsend   | typanalyze | typalign | typstorage | typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault

-----------------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+-----------+------------+-------------+-------------+------------+----------+------------+------------+-------------+-----------+----------+---------------+------------

trainings0rrtop |       145167 |    25488 |     -1 | f        | c       | t            | ,        |   145208 |       0 | record_in | record_out | record_recv | record_send | -          | d        | x          | f          |           0 |        -1 |        0 |               |

(1 row)

 

In the table pg_depend I have also e reference to 124208

Can I Also remove that dependency?

 

We are using the 8.2.5 version of PG.

 

Kind regards

Paul

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

Предыдущее
От: Reinhard Asmus
Дата:
Сообщение: Re: german sort is wrong
Следующее
От: Debanjan Bhattacharyya
Дата:
Сообщение: WAL archiving question