Re: Trigger problem

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.