infinite trigger loop

From: Veres Lajos <vlajos(at)www(dot)vatera(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: infinite trigger loop
Date: 2003-05-12 08:29:09
Message-ID: Pine.LNX.4.44.0305121024310.16443-100000@www.vatera.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ludens(dot)elte(dot)hu
+36 20 438 5909

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-05-12 08:39:19 Re: Caching Websites
Previous Message D. Dante Lorenso 2003-05-12 06:07:10 Serialization, Locking...implement processing Queue with a table