rogervellacott wrote:

> I suspect this would create an endless loop.
>
> <aharrison@...> wrote:
>> If the change must actually be done after the insert occurs,
>> you could try something like this:
>>
>> update test_table s
>> set s.kyriga = 'test'
>> where s.<primary key> = new.<primary key>
>>
>> replacing <primary key> with the name of the primary key field.
>>

It would create an infinite loop if the trigger were an after
update - or some combination that includes update. But the
trigger we're talking about is after insert.


Good luck,

Ann