X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 82F4A9F9CAA for ; Tue, 13 Jun 2006 01:55:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21960-06 for ; Tue, 13 Jun 2006 01:55:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp102.plus.mail.re2.yahoo.com (smtp102.plus.mail.re2.yahoo.com [206.190.53.27]) by postgresql.org (Postfix) with SMTP id C18879F9316 for ; Tue, 13 Jun 2006 01:55:28 -0300 (ADT) Received: (qmail 71297 invoked from network); 13 Jun 2006 04:55:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=VKDjWChIOb6RNKCZ74Ryr99teAlewYk1mXYI2fEvt72szR2trWKNcFxSGBliEvuUCkmVrlFdzuEJlOBXrTGUSfcN22+g+peRLP1iOh9wCfAbijh/q4WJCozVv045OWryj4Hzmt1Kha5fxLBYuto3Vq3+eMPVKzVpQjTtfQbYQf8= ; Received: from unknown (HELO ?192.168.20.100?) (renneyt@68.81.191.20 with plain) by smtp102.plus.mail.re2.yahoo.com with SMTP; 13 Jun 2006 04:55:27 -0000 Message-ID: <448E453D.3080207@yahoo.com> Date: Tue, 13 Jun 2006 00:55:25 -0400 From: "renneyt@yahoo.com" User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: postgres Subject: PLPGSQL/EXCEPTION HANDLING Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/112 X-Sequence-Number: 22074 In a function implemented in 7.4.8 I had the following error when I call the function: ERROR: syntax error at or near "EXCEPTION" Offending line is: EXCEPTION WHEN dup_val_on_index THEN NULL; When this line is removed, all is well. Any help appreciated...