Re: Can not pg_dumpall

From: Somazx Interesting <somazx(at)home(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can not pg_dumpall
Date: 2001-06-08 21:06:57
Message-ID: 5.1.0.14.0.20010608135049.02fd8888@mail.rct1.bc.wave.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 01:30 PM 6/8/2001 -0700, you wrote:
> > At 02:18 PM 6/8/2001 -0400, Tom Lane wrote:
> > >Somazx Interesting <somazx(at)home(dot)com> writes:
> > > > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608
> returned 0
> > > > tuples. Expected 1.
> > > > pg_dump failed on OnEd, exiting
>
>This is easy to fix, actually. You need to change reltriggers on the
>pg_class row for lessontable_548_118 to match the number of triggers that
>are really there (7).

Thanks. You've bailed me out once more. I was able to backup the data now -
and I can relax a little.

I was hoping that the problems preventing me from dropping those tables and
doing a pg_dump would resolve the slowness in the system in general
(especially dropping tables) - and it did!!

Does that make any sense though?

Andy.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-06-08 21:23:02 Re: Cleanly cancel a query.
Previous Message Thalis A. Kalfigopoulos 2001-06-08 21:04:07 Re: Cleanly cancel a query.