Re: [SQL] calling function from rule

2003-01-24 Thread Tambet Matiisen
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 7:01 PM To: Tambet Matiisen Cc: [EMAIL PROTECTED] Subject: Re: [SQL] calling function from rule Tambet Matiisen [EMAIL PROTECTED] writes: Try 7.3, we changed the rules about

[SQL] calling function from rule

2003-01-23 Thread Tambet Matiisen
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

Re: [SQL] calling function from rule

2003-01-23 Thread Tom Lane
Tambet Matiisen [EMAIL PROTECTED] 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

Re: [SQL] calling function from rule

2003-01-23 Thread Tambet Matiisen
Tambet Matiisen [EMAIL PROTECTED] 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

Re: [SQL] calling function from rule

2003-01-23 Thread Tom Lane
Tambet Matiisen [EMAIL PROTECTED] writes: Try 7.3, we changed the rules about returned records count. I have 7.3. When rule and action are the same, everything works fine. Doing an insert in update rule and opposite are OK too. Problem is, when I do select in insert/update/delete rule. Then