Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5619F475AD7
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 08:27:34 -0500 (EST)
Received: from manica.mvweb.de (unknown [212.184.88.123])
	by postgresql.org (Postfix) with SMTP id D82DC47605F
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 08:27:32 -0500 (EST)
Received: (qmail 28536 invoked from network); 29 Jan 2003 13:34:21 -0000
Received: from sn-gw.mv.de (HELO mvweb.de) (212.184.88.121)
	by manica.mvweb.de with SMTP; 29 Jan 2003 13:34:21 -0000
Message-ID: <3E37D737.90902@mvweb.de>
Date: Wed, 29 Jan 2003 14:29:27 +0100
From: Tony Simbine <jantos-work@mvweb.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
X-Accept-Language: de, pt, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: help: triggers
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/486
X-Sequence-Number: 11351

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();

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