--- Tim Perdue <[EMAIL PROTECTED]> wrote: > I have created a function in pl/pgsql to modify a > row before it gets put > into the database, but it seems my modification is > being ignored, and > the unmodified row is being inserted. > > I have confirmed with this RAISE EXCEPTION that my > "NEW" row is modified > properly, however it is not being stored in the db. > > NEW.start_date := NEW.start_date+delta; > -- RAISE EXCEPTION ''new start date: % > '',NEW.start_date; > NEW.end_date := NEW.end_date+delta; > > It's probably something very obvious, but I'm > mystified. > > CREATE TRIGGER projtask_insert_depend_trig AFTER > INSERT ON project_task > FOR EACH ROW EXECUTE PROCEDURE > projtask_insert_depend(); > >
Try changing the "AFTER" to "BEFORE" CREATE TRIGGER projtask_insert_depend_trig BEFORE... Changes made to the "NEW" will not be reflect in the AFTER trigger since, the row is already inserted. __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
