Re: calling function from rule

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)ee>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: calling function from rule
Date: 2003-01-23 15:30:00
Message-ID: 26021.1043335800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)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 of the table is done. Also the function must be called in the same transaction as update. I tried to define an additional update 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tambet Matiisen 2003-01-23 15:55:39 Re: calling function from rule
Previous Message Tomasz Myrta 2003-01-23 14:43:29 Re: Slow query