help: triggers

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: Raw Message | Whole Thread | 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();

##########################################################

Responses

Browse pgsql-sql by date

  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