Re: infinite trigger loop

Erick Dennis wrote:
> I don't know what you trigger are doing, but, you can't check if the
> update was already made? before try to update it!.

Sort of a solution ... put "... AND att != OLD.att" into the updates
performed by the triggers and it's not looping.

Jan

>
>
> On Mon, 12 May 2003, Veres Lajos wrote:
>
>
>>Hello,
>>
>>I would like to synchronize 2 tables.
>>I think that maybe triggers are the best solution.
>>But, if i create two update trigger, when i update the first table first
>>trigger update the other, and the other trigger also try to update the
>>first table... and this is an infinite loop.
>>At now, in all two triggers i first drop the other and after the update
>>recreate.
>>I think that this is not the _best_ solution.
>>Can you show me a better solution?
>>thanks.
>>
>>PS:
>>please CC: for my personal e-mail address, I'm not subscribed.
>>
>>Veres Lajos
>>vlajos(at)ludens(dot)elte(dot)hu
>>+36 20 438 5909
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>message can get through to the mailing list cleanly
>>
>
>

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #