Re: too many trigger records found for relation "item" - what's that about??

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: too many trigger records found for relation "item" - what's that about??
Дата
Msg-id 10482.1169531150@sss.pgh.pa.us
обсуждение исходный текст
Ответ на too many trigger records found for relation "item" - what's that about??  ("Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov>)
Список pgsql-general
"Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov> writes:
> postgres=# select * from item;
> ERROR:  too many trigger records found for relation "item"

You could reset the pg_class.reltriggers entry for "item" to be however
many pg_trigger entries there actually are for the table.  I'm curious
how you got into this state though... what PG version is this, and have
you been doing any hand manipulation of triggers?

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Password encryption method
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Regular expressions and arrays and ANY() question