Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: pg_dump: schema with OID xxxxxxxx does not exist



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group