View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002336||SymmetricDS||Improvement||public||2015-06-26 21:47||2019-08-26 08:45|
|Target Version||Fixed in Version|
|Summary||0002336: Data sync is not happening due to default AFTER INSERT trigger|
|Description||Data sync between primary and backup node is not working because of a rule is created on user table saying on insert move the data to different table hence sync is not happening.|
To get around this problem i need create BEFORE INSERT for all the user table, by default sym_trigger creates AFTER INSERT trigger.
Could you please help in creating BEFORE INSERT trigger?
What database platform is this? Are you talking about an INSTEAD OF trigger that is performed to put data into a different table? Because a BEFORE trigger won't prevent the data from being inserted, like you described, unless it raises an exception, will roll back data anyway. Maybe you should be syncing the table where the final data will be.
We use an AFTER trigger to capture the data that will be committed. If we used a BEFORE trigger, we'd miss the data that is generated by triggers or the database, such as a generated identity on a primary key.
||Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.|
|2015-06-26 21:47||shunmugaraj||New Issue|
|2019-04-23 14:40||elong||Assigned To||=> elong|
|2019-04-23 14:40||elong||Status||new => feedback|
|2019-04-23 14:40||elong||Note Added: 0001420|
|2019-04-23 14:41||elong||Tag Attached: trigger|
|2019-08-26 08:45||admin||Note Added: 0001590|
|2019-08-26 08:45||admin||Status||feedback => closed|