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 2DD5A9FA5EA for ; Tue, 13 Jun 2006 10:56:34 -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 78650-10 for ; Tue, 13 Jun 2006 10:56:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp110.plus.mail.re2.yahoo.com (smtp110.plus.mail.re2.yahoo.com [206.190.53.35]) by postgresql.org (Postfix) with SMTP id 21EC39FA12F for ; Tue, 13 Jun 2006 10:56:29 -0300 (ADT) Received: (qmail 40113 invoked from network); 13 Jun 2006 13:56:27 -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:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=rbLjdNdxQylxDM1KGV7ltqBrwBLpoP85b99dIl1HZoEisXVRr7vFU9X+7ST0uvXDFrxJ6KlXST7aOCYuhDFXqB29t4zk3NmaRQwksF/7HadVp/5gWTzQVoJmiFJKFu5aDa1GoGBxLyzkBNjLXBuJaFMPPdvAnhEsYr2zCovEHsw= ; Received: from unknown (HELO ?192.168.20.100?) (renneyt@68.81.191.20 with plain) by smtp110.plus.mail.re2.yahoo.com with SMTP; 13 Jun 2006 13:56:27 -0000 Message-ID: <448EC40A.5020102@yahoo.com> Date: Tue, 13 Jun 2006 09:56:26 -0400 From: "renneyt@yahoo.com" User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Jaime Casanova CC: postgres Subject: Re: PLPGSQL/EXCEPTION HANDLING References: <448E453D.3080207@yahoo.com> In-Reply-To: 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/114 X-Sequence-Number: 22076 Jaime Casanova wrote: > On 6/12/06, renneyt@yahoo.com wrote: >> 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. >> > > that's because that construction was added in 8.0, you have to upgrade > to use it > What part of the original construction is not supported? Are any "exception when" statements supported? Thanks