Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 898E99FA17D for ; Tue, 5 Dec 2006 15:17:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 21568-03 for ; Tue, 5 Dec 2006 15:16:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.236]) by postgresql.org (Postfix) with ESMTP id 7D5209FB2A2 for ; Tue, 5 Dec 2006 15:16:55 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i31so1657355wra for ; Tue, 05 Dec 2006 11:16:54 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=sHyls80bt1Lkp+nBgxf7hZ6aA1H7cQtHxNepw8ObGVVmrLulCHGWPuIxL2okQccYB6NIakkikeGxQd48XnVE6VBxyavn/T3QaFoyTc615vASclhfjiLVp1IZm3gXbcKl7gEqKck5VIQPDv4Dl1ejG4WFHbqlbly1jfuF9TEuAzc= Received: by 10.90.78.9 with SMTP id a9mr10007518agb.1165346213862; Tue, 05 Dec 2006 11:16:53 -0800 (PST) Received: by 10.90.78.14 with HTTP; Tue, 5 Dec 2006 11:16:53 -0800 (PST) Message-ID: <5e598f550612051116i2973bf31re7cec0705b287f18@mail.gmail.com> Date: Tue, 5 Dec 2006 20:16:53 +0100 From: "Andrzej Kwiatkowski" To: pgsql-admin@postgresql.org. Subject: problems with plperl trigger function MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/170 X-Sequence-Number: 23962 Hi, I've got a very simply in my mind problem with trigger functions. My functions returns SKIP in some cases. But when i execute a statement with psql or with api postgresql didn't return error but in psql: DELETE 0 or INSERT 0 0 and in my CGI scipts situation is the same. how can i find that execute was broken by trigger ? Thanks in advance