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 |
