[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 rul

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 ru

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 additio

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

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 PROTECTE