Re: Can not pg_dumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: Can not pg_dumpall
Date
Msg-id 10800.992032854@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can not pg_dumpall  (Somazx Interesting <somazx@home.com>)
List pgsql-general
Somazx Interesting <somazx@home.com> writes:
> 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

Now you know which table it was on ;-)

You can fix this by adjusting the reltriggers field of pg_class for that
table.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Can not pg_dumpall
Next
From: Dennis
Date:
Subject: Cleanly cancel a query.