Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7A71F9FBD58 for ; Mon, 4 Jun 2007 11:52:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 37491-05 for ; Mon, 4 Jun 2007 11:52:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 039D09FBC6B for ; Mon, 4 Jun 2007 11:52:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l54Eqm5H019468; Mon, 4 Jun 2007 10:52:49 -0400 (EDT) To: "Bart Degryse" cc: pgsql-sql@postgresql.org Subject: Re: perlu: did I find a bug, or did I make one? In-reply-to: <466405B4.A3DD.0030.0@indicator.be> References: <465D44F3.A3DD.0030.0@indicator.be><20070530141349.GA76707@winni e.fuhr.org> <466405B4.A3DD.0030.0@indicator.be> Comments: In-reply-to "Bart Degryse" message dated "Mon, 04 Jun 2007 12:29:40 +0200" Date: Mon, 04 Jun 2007 10:52:48 -0400 Message-ID: <19467.1180968768@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/12 X-Sequence-Number: 28502 "Bart Degryse" writes: > CREATE TRIGGER "afh_test_tr" BEFORE INSERT > ON "public"."afh_test" FOR EACH ROW > EXECUTE PROCEDURE "public"."temp_func1"(); > > CREATE OR REPLACE FUNCTION "public"."temp_func1" () RETURNS trigger AS > $body$ > BEGIN > IF NEW.dataareaid =3D 'lil' THEN > RAISE EXCEPTION '% foutje %', NEW.dataareaid, NEW.name; > elsIF NEW.dataareaid =3D 'bol' THEN > RAISE EXCEPTION '% nog een foutje %', NEW.dataareaid, NEW.name; > END IF; > RETURN NULL; > END; > $body$ > LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER; You probably don't want this trigger doing RETURN NULL; that's turning all your inserts into no-ops. regards, tom lane