From: | "Paul Wouters" <paul(dot)wouters(at)resilion(dot)be> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dump: schema with OID 145167 does not exist |
Date: | 2012-03-22 13:54:36 |
Message-ID: | 000001cd0833$5197f580$f4c7e080$@wouters@resilion.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-03-22 15:39:53 | Re: german sort is wrong |
Previous Message | Debanjan Bhattacharyya | 2012-03-22 12:28:35 | WAL archiving question |