Trigger Problem
От | Ramesh PAtel |
---|---|
Тема | Trigger Problem |
Дата | |
Msg-id | 3EA54AC9.20255.CE8DCD@localhost обсуждение исходный текст |
Ответы |
Re: Trigger Problem
|
Список | pgsql-novice |
Hi All i have problem in Trigger functoin when trigger fire then ERROR massage is ERROR : Attribute 'UNDEF00' not found PostgreSQL status:PGRES_FATAL_ERROR here UNDEF00 is by defult value of po_no TRIGGER IS CREATE TRIGGER add_stock_gr_trig AFTER UPDATE on gr FOR EACH ROW execute procedure add_stock_gr_fun(); my function is this create function add_stock_gr_fun() returns opaque as' DECLARE rec RECORD; txtpo varchar; BEGIN IF NEW.po_no <> "UNDEF00" THEN SELECT INTO rec gr_no, noofbags, final_wt, matl_cd FROM po p, gr g WHERE g.po_no=p.po_no and g.gr_no=NEW.gr_no; IF OLD.po_no #= "UNDEF00" THEN UPDATE matl_mst SET bal_bag = bal_bag + rec.noofbags, bal_kg= bal_kg + rec.final_wt WHERE matl_mst.matl_cd = rec.matl_cd; ELSE UPDATE matl_mst SET bal_bag = bal_bag + NEW.noofbags - OLD.noofbags, bal_kg= bal_kg + NEW.final_wt - OLD.final_wt WHERE matl_mst.matl_cd = rec.matl_cd; END IF; END IF; return NULL; END;' language 'plpgsql'; please Help me Ramesh Patel
В списке pgsql-novice по дате отправления: