pg_dump: schema with OID 145167 does not exist

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

Responses

Browse pgsql-admin by date

  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