| From: | Tony Simbine <jantos-work(at)mvweb(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | help: triggers |
| Date: | 2003-01-29 13:29:27 |
| Message-ID: | 3E37D737.90902@mvweb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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();
##########################################################
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Hidders | 2003-01-29 13:48:56 | Re: double linked list |
| Previous Message | Moritz Lennert | 2003-01-29 13:24:22 | Re: plpgsql: return results of a dynamic query |