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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
