Trigger problem - Mailing list pgsql-general

Hi all

I'm having a problem with PostgreSQL 7.4.6-2

I do:

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

and I get:

ERROR:  record "new" is not assigned yet
DETAIL:  The tuple structure of a not-yet-assigned record is
indeterminate.
CONTEXT:  PL/pgSQL function "myfunc" line 2 at SQL statement

Thanks for you help!


--
Henry Molina
R&D
CMN Consulting