Re: calling function from rule - Mailing list pgsql-sql

From Tom Lane
Subject Re: calling function from rule
Date
Msg-id 26021.1043335800@sss.pgh.pa.us
Whole thread Raw
In response to calling function from rule  ("Tambet Matiisen" <t.matiisen@aprote.ee>)
List 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 by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: Slow query
Next
From: "Tambet Matiisen"
Date:
Subject: Re: calling function from rule