pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Neish <peter@austehc.unimelb.edu.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump: schema with OID xxxxxxxx does not exist
Date: Mon, 30 Oct 2006 13:12:51 +1100
Message-ID: <45455FA3.2080706@austehc.unimelb.edu.au> (raw)
In-Reply-To: <6801.1161967193@sss.pgh.pa.us>
References: <45418477.2020400@austehc.unimelb.edu.au>
	<6801.1161967193@sss.pgh.pa.us>

Tom Lane wrote:
> Peter Neish <peter@austehc.unimelb.edu.au> writes:
>   
>>  entity_browse_bid_seq |     37647910 |     1005 |      4 | t        | 
>> c       | t            | ,        | 37894096 |       0 | record_in | 
>> record_out | record_recv | record_send | i        | p          | 
>> f          |           0 |        -1 |        0 |               |
>>  entity_browse         |     37647910 |     1005 |      4 | t        | 
>> c       | t            | ,        | 37894098 |       0 | record_in | 
>> record_out | record_recv | record_send | i        | p          | 
>> f          |           0 |        -1 |        0 |               |
>> (2 rows)
>>     
>
>   
>> Does this mean that I can just delete these rows from this table for the 
>> dump to work? Will deleting these rows affect anything else?
>>     
>
> These are composite-type entries, which means there should be
> associated entries in pg_class --- with OIDs 37894096 and 37894098
> respectively.  Did you check to see if those are still there?
>   

Yes, they are there. Can I safely delete the rows from both the pg_type 
and the pg_class tables?

> We've seen scattered reports of table rowtype entries not being removed
> when the owning table is dropped, but no one's ever been able to make a
> reproducible case :-(.  Do you know anything about the history or usage
> of these tables?
>   
I am afraid I inherited this database from a previous admin, so I know 
nothing of its history - sorry...

Peter.



view thread (7+ messages)  latest in thread

Message-ID: <45455FA3.2080706@austehc.unimelb.edu.au>
Permalink:  ../45455FA3.2080706@austehc.unimelb.edu.au/
Also on:    postgresql.org/message-id/45455FA3.2080706@austehc.unimelb.edu.au

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: peter@austehc.unimelb.edu.au, tgl@sss.pgh.pa.us
  Subject: Re: pg_dump: schema with OID xxxxxxxx does not exist
  In-Reply-To: <45455FA3.2080706@austehc.unimelb.edu.au>
  References: <45418477.2020400@austehc.unimelb.edu.au> <6801.1161967193@sss.pgh.pa.us> <45455FA3.2080706@austehc.unimelb.edu.au>

* 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