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.