It would be better if you could provide the source of that trigger and involved table schemas?
Wei ----- Original Message ----- From: "Tony Simbine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 8:29 AM Subject: [SQL] help: triggers > hello, > > I'm trying to update a columm on a table with a trigger > but it don't work on PostgreSQL 7.2 (i686-pc-linux-gnu, compiled by GCC > 2.96). > > when I update a row the trigger does nothing. > what can I do? > > thanks in advance > > tony > > > here is my trigger: > > ######################################################## > CREATE FUNCTION update_my_objekt() RETURNS OPAQUE AS ' > BEGIN > RAISE NOTICE ''My Trigger is updating the table''; > IF OLD.status=''Activo'' THEN > NEW.tempo := 10; > NEW.actual := now(); > END IF; > RETURN NEW; > END; > ' LANGUAGE 'plpgsql'; > > > CREATE TRIGGER update_online BEFORE UPDATE ON iobjects > FOR EACH ROW EXECUTE PROCEDURE update_my_objekt(); > > ########################################################## > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster