Re: help: triggers
От | Wei Weng |
---|---|
Тема | Re: help: triggers |
Дата | |
Msg-id | 004501c2c7ae$e09ce210$5301a8c0@monet обсуждение исходный текст |
Ответ на | help: triggers (Tony Simbine <jantos-work@mvweb.de>) |
Список | pgsql-sql |
It would be better if you could provide the source of that trigger and involved table schemas? Wei ----- Original Message ----- From: "Tony Simbine" <jantos-work@mvweb.de> To: <pgsql-sql@postgresql.org> 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 >
В списке pgsql-sql по дате отправления: