Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?
Дата
Msg-id 5173.979852518@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: plpgsql: cache lookup from pg_proc failed -- Why?  ("zivit" <zivit@congruency.co.il>)
Список pgsql-novice
Дерево обсуждения 
"zivit" <zivit@congruency.co.il> writes:
> We have the following problem on executing trigger: ERROR: plpgsql: cache
> lookup from pg_proc failed.

Did you perhaps drop and recreate the function after creating the
trigger?  If so, you have to drop and recreate the trigger as well.
This is annoying, but no one's gotten around to fixing it yet ...

            regards, tom lane

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

Предыдущее
От: "Matt Friedman"
Дата:
Сообщение: creating a constraint on the same table
Следующее
От: "Stefan Waidele jun."
Дата:
Сообщение: Re: Interval output format