Re: Error in trigger after upgrading to 8.0.1?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Error in trigger after upgrading to 8.0.1?
Дата
Msg-id 29947.1107643356@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Error in trigger after upgrading to 8.0.1?  (Bjørn T Johansen <btj@havleik.no>)
Список pgsql-general
=?ISO-8859-1?Q?Bj=F8rn_T_Johansen?= <btj@havleik.no> writes:
> I have just upgraded to 8.0.1 from 7.4.6 and now my triggers doesn't work. When I insert a
> row in a table that has an insert trigger, I get the following error msg:

> ERROR:  INSERT is not allowed in a non-volatile function

> What does this mean?

Just what it says.  What are you doing declaring that trigger function
as immutable (or stable), when it has side effects?

            regards, tom lane

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

Предыдущее
От: Sven Willenberger
Дата:
Сообщение: Re: Error in trigger after upgrading to 8.0.1?
Следующее
От: Bjørn T Johansen
Дата:
Сообщение: Re: Error in trigger after upgrading to 8.0.1?