Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 71F93633770 for ; Thu, 11 Feb 2010 01:51:16 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88956-06 for ; Thu, 11 Feb 2010 05:51:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id D30A6632E89 for ; Thu, 11 Feb 2010 01:51:05 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o1B5p447002885; Thu, 11 Feb 2010 00:51:04 -0500 (EST) To: u235sentinel@gmail.com cc: pgsql-admin@postgresql.org Subject: Re: Postgres Triggers issue In-reply-to: <4B7383FA.2010509@gmail.com> References: <4B7383FA.2010509@gmail.com> Comments: In-reply-to u235sentinel message dated "Wed, 10 Feb 2010 21:13:46 -0700" Date: Thu, 11 Feb 2010 00:51:04 -0500 Message-ID: <2884.1265867464@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/87 X-Sequence-Number: 33690 u235sentinel writes: > 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? This really isn't enough information for anybody to help you. The rest of us don't know what you mean by a "feed", let alone how a trigger might stop it. Tell us what's happening at the level of SQL commands. regards, tom lane