I have a cluster of three nodes A, B, C and I'm using postgres bdr for replication.
I have some code to execute after a value change in the table, for this I have added a trigger.
When I call POST REST API from any one of the nodes it will execute the code, and on all other nodes the trigger will execute the code. The issue is the trigger will execute the code on the same node as well where POST call is happening.
Ex. POST REST API on node B. Directly execute a+b. save a and b in DB. response
Trigger activates on all nodes. And it will execute a+b on all nodes. (but I don't want to execute it again on node B)