Re: pg_dump problem

[SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx>]

Hi
The dump works now after deleting those rows from the pg_rewrite table
Thanks for your help
sharmila

----- Original Message ----
From: Tom Lane <tgl@xxxxxxxxxxxxx>
To: SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Sent: Wednesday, November 14, 2007 3:33:20 PM
Subject: Re: pg_dump problem

SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx> writes:
> looks like the OIDs are there....

Yeah, that makes it look more like the pg_class row went missing
than that there was an intentional drop of the view.

Does "VACUUM VERBOSE pg_class" report anything interesting?
It's possible also that reindexing pg_class would fix it.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

---

Be a better sports nut! Let your teams follow you 
with Yahoo Mobile. Try it now.