Re: pg_dump: schema with OID 145167 does not exist - Mailing list 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