Re: pg_dump problem
От | SHARMILA JOTHIRAJAH |
---|---|
Тема | Re: pg_dump problem |
Дата | |
Msg-id | 957241.29899.qm@web31103.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | pg_dump problem (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>) |
Список | pgsql-general |
Hi
The dump works now after deleting those rows from the pg_rewrite table
Thanks for your help
sharmila
The dump works now after deleting those rows from the pg_rewrite table
Thanks for your help
sharmila
----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 14, 2007 3:33:20 PM
Subject: Re: [GENERAL] pg_dump problem
SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> 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@postgresql.org so that your
message can get through to the mailing list cleanly
From: Tom Lane <tgl@sss.pgh.pa.us>
To: SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 14, 2007 3:33:20 PM
Subject: Re: [GENERAL] pg_dump problem
SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> 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@postgresql.org 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.
В списке pgsql-general по дате отправления: