I have a trigger that updates a target column when some other columns
change.
There is another trigger on the target column to update another table (the
column can be changed in other ways besides the first trigger).
If I update the target column directly the expected trigger fires.
But if the 1
t a trigger means we always know
when a value changes.
Thanks,
Judy
On Fri, Sep 13, 2019 at 2:08 PM Tom Lane wrote:
> Judy Loomis writes:
> > I have a trigger that updates a target column when some other columns
> > change.
> > There is another trigger on the target column
At the very least that note about this behavior should be highlighted,
probably on the Trigger Behavior page and not buried in a bunch of notes on
the Create Trigger page.
On Fri, Sep 13, 2019 at 4:03 PM Tom Lane wrote:
> Judy Loomis writes:
> > I'm going to have to really
