Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 276B12F4278 for ; Wed, 21 Mar 2012 12:24:25 -0300 (ADT) Received: from mail.indicator.cz ([194.7.127.243] helo=imss.indicator.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SANOg-0000sC-C7 for pgsql-admin@postgresql.org; Wed, 21 Mar 2012 15:24:24 +0000 Received: from imss.indicator.com (localhost [127.0.0.1]) by smtp4.imss57 (Postfix) with ESMTP id 95F7AE25F320 for ; Wed, 21 Mar 2012 16:15:45 +0100 (CET) Received: from webaccess (unknown [10.100.1.7]) by imss.indicator.com (Postfix) with ESMTP id 8AB61E25F30C for ; Wed, 21 Mar 2012 16:15:45 +0100 (CET) Received: from LAPTPAW ([10.100.101.225]) by webaccess with ESMTP; Wed, 21 Mar 2012 16:24:06 +0100 From: "Paul Wouters" To: Subject: pg_dump: schema with OID 145167 does not exist Date: Wed, 21 Mar 2012 16:23:45 +0100 Message-ID: <000001cd0776$9b20b600$d1622200$@wouters@resilion.be> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CD077E.FCE51E00" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac0HdpOoOfWh2jc4S0aU6LDfFxiH2w== Content-Language: nl-be X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201203/120 X-Sequence-Number: 39308 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01CD077E.FCE51E00 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0001_01CD077E.FCE51E00 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D 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

------=_NextPart_000_0001_01CD077E.FCE51E00--