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

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


On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
Mikko Partio napsal(a):


Should I try remove one of the duplicate rows from pg_class?

Try it with caution. You should use ctid column to refer to exact row.



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?

Regards

Mikko

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: dirty select
Следующее
От: "Mikko Partio"
Дата:
Сообщение: Re: "too many trigger records found for relation xyz"