X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5AA689DC810 for ; Thu, 16 Mar 2006 16:11:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95707-10 for ; Thu, 16 Mar 2006 16:11:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from perseverance.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by postgresql.org (Postfix) with ESMTP id 71E699DC840 for ; Thu, 16 Mar 2006 16:11:39 -0400 (AST) Received: from [132.205.47.205] (IDENT:emilu@curacao.encs.concordia.ca [132.205.47.205]) by perseverance.encs.concordia.ca (8.12.11/8.12.11) with ESMTP id k2GKBO0D000699; Thu, 16 Mar 2006 15:11:24 -0500 Message-ID: <4419C66B.9010602@encs.concordia.ca> Date: Thu, 16 Mar 2006 15:11:23 -0500 From: Emi Lu Reply-To: emilu@encs.concordia.ca User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Pedro B." CC: pgsql-sql@postgresql.org Subject: Re: About how to use "exception when ??? then " References: <4419AB1A.3070805@encs.concordia.ca> <200603161827.19462.pedro.borracha@netcabo.pt> <4419BD3A.1050903@encs.concordia.ca> <200603161957.46039.pedro.borracha@netcabo.pt> In-Reply-To: <200603161957.46039.pedro.borracha@netcabo.pt> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.43 on perseverance.encs.concordia.ca at 2006/03/16 15:11:24 EST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.136 required=5 tests=[AWL=0.136] X-Spam-Score: 0.136 X-Spam-Level: X-Archive-Number: 200603/242 X-Sequence-Number: 24588 >On Thursday 16 March 2006 19:32, Emi Lu wrote: >|> Errors I got are: >|> syntax error at or near "SQLSTATE" at character 2613 >|> LINE 58: RAISE NOTICE 'Hmmmm.... [%,%]', SQLSTATE, SQL... >|> >|> >|> Should I install any patches or do anything elese to have SQLSTATE and >|> SQLERRM work for me? > > >I'm so sorry, i had a terrible day and in the rush to reply to you, i forgot >to mention the patch i applied some time ago. > >The patch and thread talking about it can be found here: > >http://archives.postgresql.org/pgsql-patches/2005-04/msg00123.php > >This was what i used in my 8.0.6, and it worked fine ever since. :) > > Thanks a lot Pedro. Could you help me how to apply this patch such as the steps to load the patch please? By the way, I am using postgresql 8.0.1. I think the patch will work for all 8.0.x version, right? Thanks again, Ying