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

I don't think that is true. I have mutating triggers where I insert a row and then update another non-indexed column.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

prochak_at_my-dejanews.com wrote in message <6sjkv9$ktc$1_at_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 - 12:29:09 CDT