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 3BC93329E3B for ; Thu, 23 Sep 2004 18:11:50 +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 01105-10 for ; Thu, 23 Sep 2004 17:11:47 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id BD854329DB3 for ; Thu, 23 Sep 2004 18:11:47 +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 i8NHBk8A027524; Thu, 23 Sep 2004 13:11:46 -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 "Thu, 23 Sep 2004 13:04:00 -0400" Date: Thu, 23 Sep 2004 13:11:46 -0400 Message-ID: <27523.1095959506@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/211 X-Sequence-Number: 19057 "CHRIS HOOVER" writes: > They were a double quote. I switched all of the double quotes out for single > quotes but still not go. The function appears to run and return no results > but, I don't get any raises. I have even tried moving the raises to be fire > first lines in the function, but to no avail. Hmm. We saw a case just the other day where someone was mystified why they weren't getting reasonable results, and it turned out that what they were doing was editing function foo(something) and then invoking a pre-existing function foo(somethingelse). Check for similarly-named functions with different parameter lists ... regards, tom lane