Re: No mutating table with an update of the same table in a trigger?

From: <prochak_at_my-dejanews.com>
Date: Wed, 02 Sep 1998 14:33:13 GMT
Message-ID: <6sjkv9$ktc$1@nnrp1.dejanews.com>

In article <6sh6jh$3nu$1_at_newton.a2000.nl>, "Jean-Luc" <jeanluc_at_zap.a2000.nl> wrote:
> Hello everybody,
>
> A while back I was strolling through the database, when I encountered a
> before-row-insert
> trigger on a table. In it, there was an update statement of the same table
> the trigger was
> linked to. I was convinced that this would lead to an mutating table, but it
> didn't.
>
> Does anyone have a rule about when a trigger excepts with a mutating table
> (and when not)?
>
> Greetings, Jean-Luc
>

I think it might be:
if the update involves changing a column involved in the primary key, it fires the exception? but if it is updating a dependent column, it is OK?

(I'm sure someone more knowledgeable will correct me 8^)
>

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 09:33:13 CDT