On Sat, 4 Dec 2004, Henry Molina wrote: > drop table t1; > drop table t2; > create table t1 (id integer); > create table t2 (id integer); > CREATE OR REPLACE FUNCTION myfunc() RETURNS trigger AS ' > BEGIN > insert into t2 values(NEW.id); > END; > ' LANGUAGE plpgsql; > > CREATE TRIGGER > mytri > AFTER INSERT ON t1 FOR EACH STATEMENT > EXECUTE PROCEDURE myfunc(); > insert into t1 values(1);
Currently statement triggers don't have any way to get at the affected rowset. A FOR EACH ROW trigger should work for a case like the above, although I think you'll need to add a return statement to the function as well. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster