Re: pg_dump: schema with OID xxxxxxxx does not exist

Tom Lane wrote:
> Peter Neish <peter(at)austehc(dot)unimelb(dot)edu(dot)au> writes:
>
>> Tom Lane wrote:
>>
>>> 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?
>>
>
> Oh, that's interesting. Are there entries in pg_attribute for these
> tables? Look for attrelid = 37894096 or 37894098. What PG version
> is this exactly?
>
> regards, tom lane
>
>
Yes, 32 entries.

# select * from pg_attribute where attrelid = 37894096 or attrelid =
37894098;
attrelid | attname | atttypid | attstattarget | attlen | attnum |
attndims | attcacheoff | atttypmod | attbyval | attstorage | attisset |
attalign | attnotnull | atthasdef | attisdropped | attislocal | attinhcount
----------+---------------+----------+---------------+--------+--------+----------+-------------+-----------+----------+------------+----------+----------+------------+-----------+--------------+------------+-------------
37894096 | tableoid | 26 | 0 | 4 | -7
| 0 | -1 | -1 | t | p | f
| i | t | f | f | t
| 0
37894096 | cmax | 29 | 0 | 4 | -6
| 0 | -1 | -1 | t | p | f
| i | t | f | f | t
| 0
...
37894098 | bid | 23 | -1 | 4 | 10
| 0 | -1 | -1 | t | p | f
| i | t | t | f | t
| 0
(32 rows)

Its runnign PG Version 7.4.7

Cheers,

Peter