Retour
-
Titre
What does "INSTEAD OF triggers on the target machine" not supported mean? -
Description
What does "INSTEAD OF triggers on the target machine" not supported mean? -
Résolution
Shareplex doesn't support 'INSTEAD OF trigger' means that sp_add_trigger.sql can't wrap this type of trigger.
User can still manually modify each instead of trigger on target to make it work.
Eg:
User can manually add 'an if' statement at the beginning of the transaction to have it not fire for shareplex user, if he/she needs the trigger to be enabled on target.
CREATE OR REPLACE TRIGGER "MCS"."T_VW_CREDIT_CARD01" INSTEAD OF
INSERT
OR UPDATE
OR DELETE ON "MCS"."CREDIT_CARD" begin
If user !='SPLEX' then
if inserting then
...