[GENERAL] constraint trigger

2009-04-03 Thread Komaravolu, Satya
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

Re: [GENERAL] constraint trigger

2009-04-03 Thread Tom Lane
Komaravolu, Satya satya.komarav...@gilbarco.com writes: 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

Re: [GENERAL] constraint trigger

2009-04-03 Thread Tom Lane
Komaravolu, Satya satya.komarav...@gilbarco.com writes: The SQL file is failing on the following error. I gave you that message as it was the first one for the list of CONSTRAINT TRIGGER statements. NOTICE: converting trigger group into constraint unnamed FOREIGN KEY