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