X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 724D9329EB7 for ; Tue, 21 Sep 2004 23:29:21 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11614-08 for ; Tue, 21 Sep 2004 22:29:10 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5491D329EA5 for ; Tue, 21 Sep 2004 23:29:11 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i8LMTA0u004075; Tue, 21 Sep 2004 18:29:11 -0400 (EDT) To: "CHRIS HOOVER" Cc: pgsql-sql@postgresql.org Subject: Re: raise is not working In-reply-to: References: Comments: In-reply-to "CHRIS HOOVER" message dated "Tue, 21 Sep 2004 12:44:00 -0400" Date: Tue, 21 Sep 2004 18:29:10 -0400 Message-ID: <4074.1095805750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/196 X-Sequence-Number: 19042 "CHRIS HOOVER" writes: > SQL_Str is defined as a varchar. Neither of the raise calls have done > anything, but I don't get any errors either. The only way RAISE EXCEPTION "isn't going to do anything" is if control doesn't get to it. My bet would be that you are invoking some other function than you think you are --- we've seen examples of that sort of mistake recently. Check for multiple functions with same name and different argument types. regards, tom lane