DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:reply-to:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=FdQILz1qFqoHDAr+GidBRgOo0FGip0hnV+L2XJonKuW644koksT7nloJA74sKja3EQ
	zsWlprDUbCd/pdgJl4DaEkRBBAM7+paVVkQW+zWM6qoxzTjwN/qkrESM8dAcDZDzJS94
	RTZM09cb4hW7ljkvN4SOwLZjdN5AdhQrbG3vc=
Message-ID: <4B7383FA.2010509@gmail.com>
Date: Wed, 10 Feb 2010 21:13:46 -0700
From: u235sentinel <u235sentinel@gmail.com>
Reply-To: u235sentinel@gmail.com
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Postgres Triggers issue
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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