Re: Can not pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can not pg_dumpall
Дата
Msg-id 10800.992032854@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Can not pg_dumpall  (Somazx Interesting <somazx@home.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Can not pg_dumpall
Следующее
От: Dennis
Дата:
Сообщение: Cleanly cancel a query.