Re: calling function from rule

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: calling function from rule
Дата
Msg-id 26021.1043335800@sss.pgh.pa.us
обсуждение исходный текст
Ответ на calling function from rule  ("Tambet Matiisen" <t.matiisen@aprote.ee>)
Список pgsql-sql
"Tambet Matiisen" <t.matiisen@aprote.ee> writes:
> I have a view and update rule on it, which updates another table. Now I would like to call a function, after update
ofthe table is done. Also the function must be called in the same transaction as update. I tried to define an
additionalupdate rule on the view, but doing a SELECT in update rule spoils the affected records count:
 

Try 7.3, we changed the rules about returned records count.
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/rules-status.html
        regards, tom lane


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

Предыдущее
От: Tomasz Myrta
Дата:
Сообщение: Re: Slow query
Следующее
От: "Tambet Matiisen"
Дата:
Сообщение: Re: calling function from rule