Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 77758FA6B9C for ; Thu, 22 Mar 2012 10:55:15 -0300 (ADT) Received: from mail.apuntesyconsejos.es ([194.7.127.243] helo=imss.indicator.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAiTx-0005ms-P1 for pgsql-admin@postgresql.org; Thu, 22 Mar 2012 13:55:15 +0000 Received: from imss.indicator.com (localhost [127.0.0.1]) by smtp4.imss57 (Postfix) with ESMTP id E87FBE2649D2 for ; Thu, 22 Mar 2012 14:46:35 +0100 (CET) Received: from webaccess (unknown [10.100.1.7]) by imss.indicator.com (Postfix) with ESMTP id DB526E264973 for ; Thu, 22 Mar 2012 14:46:35 +0100 (CET) Received: from LAPTPAW ([10.100.101.225]) by webaccess with ESMTP; Thu, 22 Mar 2012 14:54:58 +0100 From: "Paul Wouters" To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CD083B.B35C5D80" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac0HdpOoOfWh2jc4S0aU6LDfFxiH2w== Content-Language: nl-be X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/113 X-Sequence-Number: 39301 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01CD083B.B35C5D80 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_01CD083B.B35C5D80 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_01CD083B.B35C5D80--