X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4EDBD475AA9 for ; Sat, 19 Apr 2003 12:43:16 -0400 (EDT) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by postgresql.org (Postfix) with SMTP id 6DA964758C9 for ; Sat, 19 Apr 2003 12:43:13 -0400 (EDT) Received: (qmail 6297 invoked by uid 505); 19 Apr 2003 16:43:18 -0000 Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with qmail-scanner-1.15 (uvscan: v4.1.60/v4171. Clear:. Processed in 1.689049 secs); 19 Apr 2003 16:43:18 -0000 Received: from unknown (HELO system67.trade-india-local.com) (203.196.129.235) by ns5.trade-india.com with SMTP; 19 Apr 2003 16:43:16 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Tom Lane Subject: Re: replicable problem with PL/Perl Date: Sat, 19 Apr 2003 22:12:56 +0530 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <200304191216.46925.mallah@trade-india.com> <22186.1050770063@sss.pgh.pa.us> In-Reply-To: <22186.1050770063@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200304192212.56529.mallah@trade-india.com> X-Spam-Status: No, hits=-33.1 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/305 X-Sequence-Number: 13006 Thanks Tom, and sorry for the repost :) regds mallah. On Saturday 19 Apr 2003 10:04 pm, Tom Lane wrote: > Rajesh Kumar Mallah writes: > > if one pl/perl function raises an ERROR even other pl/perl > > functions stop working and keep rasing the previous error > > This was reported before: > http://archives.postgresql.org/pgsql-hackers/2002-10/msg00170.php > > I'm not convinced that John's proposed fix is correct though > (see followup discussion). Someone should bring up the issue > with some Perl gurus and see whether clearing $@ is really an > appropriate thing to do. > > regards, tom lane -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.