Trigger loop question - Mailing list pgsql-general

From Mike Nolan
Subject Trigger loop question
Date
Msg-id 200403160001.i2G012lL025044@gw.tssi.com
Whole thread Raw
Responses Re: Trigger loop question
List pgsql-general
I have some information that that I need to keep synchronized which can
be found in two different tables.   (Yes, it's not fully normalized.)

If I set up an on update trigger for table 'A' that updates the
corresponding column in table 'B', and one for table 'B' that updates
the corresponding column in table 'A', does that create an endless loop?
--
Mike Nolan

pgsql-general by date:

Previous
From: Edwin Pauli
Date:
Subject: Re: PostgeSQL problem (server crashed?)
Next
From: Tom Lane
Date:
Subject: Re: Trigger loop question