Re: Can not pg_dumpall

On Fri, 8 Jun 2001, Somazx Interesting 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
> >
> >Kinda looks like you dropped some function that was still referenced by
> >a trigger. Better drop the trigger too.
>
> Taking that to mean, "try deleting that orphaned trigger" - but since I
> don't know which table that trigger was on - I did it by deleting it
> through pg_trigger, I now get somewhat worse errors:
>
> getTables(): relation 'lessontable_548_118': 8 Triggers were expected, but
> got 7
>

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