pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: DIEGO ARMANDO LOPEZ PINILLA <diego.lopez@telecom.net.co>
Cc: pgsql-admin@postgresql.org
Subject: Re: Telecom(Colombia) - Error postgresql
Date: Wed, 12 Sep 2007 18:48:21 -0400
Message-ID: <20070912224821.GF6627@alvh.no-ip.org> (raw)
In-Reply-To: <410F18AA90054F4F96A520CA757D556C02FF14D1@WBOGEX01.telecom.esp>
References: <410F18AA90054F4F96A520CA757D556C02FF14D1@WBOGEX01.telecom.esp>

DIEGO ARMANDO LOPEZ PINILLA wrote:

> De pronto me podrían colaborar con la solución de este inconveniente:
> 
> postgres@lbogap02:~> pg_dump tollticketing > prueba.backup
> 
> pg_dump: schema with OID 128157747 does not exist

El problema es que hay un catalogo que hace referencia a ese schema, que
no existe.  La solucion pasa por saber cual es ese catalogo.  No hay
muchos catalogos que tengan un namespace; prueba lo siguiente:

select attrelid::regclass, attname from pg_attribute join pg_class on
(oid = pg_attribute.attrelid) where attname like '%namespace' and
relkind = 'r';

Eso te va a dar un listado de catalogos y el nombre de la columna.  A
continuacion, para cada nombre del listado, haz

select * from pg_type where typnamespace = '128157747';

(reemplaza nombre de catalogo y columna segun corresponda).

Cuando encuentres uno que tiene ese valor, muestralo aca y vemos que se
hace con el.



-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you are."  -- Charles J. Sykes' advice to teenagers



view thread (2+ messages)

Message-ID: <20070912224821.GF6627@alvh.no-ip.org>
Permalink:  ../20070912224821.GF6627@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070912224821.GF6627@alvh.no-ip.org

 · 

reply

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: alvherre@commandprompt.com, diego.lopez@telecom.net.co
  Subject: Re: Telecom(Colombia) - Error postgresql
  In-Reply-To: <20070912224821.GF6627@alvh.no-ip.org>

* 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