From: | "Komaravolu, Satya" <satya(dot)komaravolu(at)gilbarco(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | constraint trigger |
Date: | 2009-04-03 15:40:17 |
Message-ID: | 0E0566DAE945074C83ABBE48DC9C91E702F85781@dhrseasvxb03.messaging.danaherad.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mahlon E. Smith | 2009-04-03 16:18:08 | Re: How to capture an interactive psql session in a log file? |
Previous Message | Tom Lane | 2009-04-03 14:58:24 | Re: Rule or Function and Trigger? |