Re: "too many trigger records found for relation xyz"

Поиск
Список
Период
Сортировка
От Mikko Partio
Тема Re: "too many trigger records found for relation xyz"
Дата
Msg-id 2ca799770804080738i7b653285l9889667b79ac4ee5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "too many trigger records found for relation xyz"  ("Mikko Partio" <mpartio@gmail.com>)
Ответы Re: "too many trigger records found for relation xyz"
Список pgsql-general
Дерево обсуждения


On Tue, Apr 8, 2008 at 5:26 PM, Mikko Partio <mpartio@gmail.com> wrote:

Ok I removed the faulty tuple and nothing catastrophical happened. I can do a pg_dump now, but I still can't remove the one remaining table:

# drop table xyz ;

ERROR:  too many trigger records found for relation "xyz"

Any insight for this problem?



I managed to solve the situation with the help of this thread: http://archives.postgresql.org/pgsql-bugs/2007-02/msg00167.php

Everything seems to be ok for now, but I'm still curious what caused to whole mess to begin with.

Thanks a lot for your help again.

Regards

Mikko

В списке pgsql-general по дате отправления:

Предыдущее
От: "Mikko Partio"
Дата:
Сообщение: Re: "too many trigger records found for relation xyz"
Следующее
От: paul tilles
Дата:
Сообщение: ecpg-timestamp- interval problem V8.2.x