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.
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. |