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
"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
>
> "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
"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
> -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