From: Paul Wouters <paul.wouters@resilion.be>
To: pgsql-admin@postgresql.org
Subject: pg_dump: schema with OID 145167 does not exist
Date: Thu, 22 Mar 2012 14:54:36 +0100
Message-ID: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: paul.wouters@resilion.be
Subject: Re: pg_dump: schema with OID 145167 does not exist
In-Reply-To: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox