constraint trigger

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.

Responses

Browse pgsql-general by date

  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?