Hi I'm running into the following error when i create a CONSTRAINT TRIGGER.
NOTICE: ignoring incomplete trigger group for constraint "<unnamed>" FOREIGN KEY cd_card(tender) REFERENCES cd_tender(id) DETAIL: Found referenced table's DELETE trigger. for the following statement CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "cd_tender" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'cd_card', 'cd_tender', 'UNSPECIFIED', 'tender', 'id'); could you please tell how to solve this. Also can you tell what the function arguments mean. I know so much that these parameters anre table and column names. but not sure what "<unnamed>" and 'UNSPECIFIED' stand for. Also i notice that if i remove "<unnamed>" and 'UNSPECIFIED' the trigger gets created but not sure of behavior. it is a combination of RI_FKey_noaction_del and "<unnamed>" and 'UNSPECIFIED' is causing the problem. thanks satya Please be advised that this email may contain confidential information. If you are not the intended recipient, please do not read, copy or re-transmit this email. If you have received this email in error, please notify us by email by replying to the sender and by telephone (call us collect at +1 202-828-0850) and delete this message and any attachments. Thank you in advance for your cooperation and assistance. In addition, Danaher and its subsidiaries disclaim that the content of this email constitutes an offer to enter into, or the acceptance of, any contract or agreement or any amendment thereto; provided that the foregoing disclaimer does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment to this email.