What I found interesting is that the subscription table appears to permit
INSERT because you need to
CREATE it as you normally work.
I want to make a bidirectional subscription from database A and B such that table T has records "owned" by either A or B and only changes make by the owner are recorded.
INSERT INTO A.T VALUES ('rowA'); INSERT INTO B.T VALUES ('rowB');
Then due to the replication, both databases have this record. But due to the pub/sub "ownership", only the following operations actually have an effect.
DELETE FROM A.T WHERE value = 'rowA'; DELETE FROM B.T WHERE value = 'rowB';
DELETE FROM B.T WHERE value = 'rowA'; DELETE FROM A.T WHERE value = 'rowB';
don't have an effect because the ownership is off.
Is this possible?
originally posted in StackOverflow, but moving it here