Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-03-22 15:39:53
Subject: Re: german sort is wrong
Previous:From: Debanjan BhattacharyyaDate: 2012-03-22 12:28:35
Subject: WAL archiving question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group