Postgres Triggers issue - Mailing list pgsql-hackers

From u235sentinel
Subject Postgres Triggers issue
Date
Msg-id 4B730B6F.8040105@gmail.com
Whole thread Raw
In response to Re: Some belated patch review for "Buffers" explain analyze patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres Triggers issue
List pgsql-hackers
I have a strange problem we noticed the other day with triggers.  We're 
running 8.3.3 on Solaris 10 (intel) and have a feed that comes in 
regularly to populate a table we're working on.  The feed works just 
fine inserting rows however the following trigger stops the feed until 
we remove the trigger.  Any thoughts on what I'm doing wrong here?

Thanks!

---

CREATE OR REPLACE FUNCTION r.m_t()
RETURNS trigger AS
$BODY$
BEGIN INSERT INTO temp_m_t VALUES (NEW.*,1+1);
RETURN NULL;
END;
$BODY$
LANGUAGE 'plpgsql';

CREATE TRIGGER tafter
AFTER INSERT OR UPDATE
ON r.m_a
FOR EACH ROW
EXECUTE PROCEDURE r.m_t();



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [CFReview] Red-Black Tree
Next
From: Robert Haas
Date:
Subject: Re: Writeable CTEs and empty relations