Re: pg_dump: schema with OID xxxxxxxx does not exist

[Peter Neish <peter(at)austehc(dot)unimelb(dot)edu(dot)au>]

Tom Lane wrote:
> Peter Neish <peter(at)austehc(dot)unimelb(dot)edu(dot)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.