infinite trigger loop - Mailing list pgsql-general

From Veres Lajos
Subject infinite trigger loop
Date
Msg-id Pine.LNX.4.44.0305121024310.16443-100000@www.vatera.hu
Whole thread Raw
Responses Re: infinite trigger loop  (Erick Dennis <edennis@rootshell.be>)
List pgsql-general
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@ludens.elte.hu
+36 20 438 5909


pgsql-general by date:

Previous
From: Chris Cameron
Date:
Subject: MSSQL -> PostgreSQL
Next
From: "Vincenzo Alberico"
Date:
Subject: Datatype Definition