pg_dump: schema with OID 1 does not exist

[Christian Platzer]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there.
We have a big problem with one of our databases.
Postgres Server 7.3

When we try to backup the database, pg_dump exits with the following error:
pg_dump: schema with OID 1 does not exist
The same issue appears when we copy the entire database and try it again.

All the data are stored in the public schema.

Thanks a lot for helping me!

Christian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBEc66BaT26XNCfvQRAn2uAJ4gN+tFuNaxllRmEKls3Bm0/jg8qQCfasTg
Fu1QcPD4CvTj0ZAXmHR+NyU=
=FtuX
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Post by Christian Platzer
pg_dump: schema with OID 1 does not exist

Say again about your software version? There is no such message in 7.3
pg_dump.

But anyway, I'd suggest looking through the system catalogs for objects
with 1 in their xxxnamespace field (pg_class.relnamespace,
pg_type.typnamespace, etc). What you ultimately want to do, I suspect,
is manually update the namespace field for any such object. But first
it would be interesting to understand how it got into this state.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html