Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0BD9F64FCC4 for ; Tue, 9 Sep 2008 09:12:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85996-07 for ; Tue, 9 Sep 2008 09:12:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CFCFF64FD25 for ; Tue, 9 Sep 2008 09:12:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m89CBjUv022556; Tue, 9 Sep 2008 08:11:45 -0400 (EDT) To: "Ryan Bradetich" cc: "Jaime Casanova" , pgsql-patches Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2] In-reply-to: References: <3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com> <3073cc9b0809062330o62fd74dax74b1730cedc0fbb9@mail.gmail.com> <3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com> Comments: In-reply-to "Ryan Bradetich" message dated "Mon, 08 Sep 2008 23:25:31 -0700" Date: Tue, 09 Sep 2008 08:11:45 -0400 Message-ID: <22555.1220962305@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/101 X-Sequence-Number: 7116 "Ryan Bradetich" writes: > I am assuming you are seeing this error in the uint_test1.sql: > ERROR: could not find hash function for hash operator 16524 > I can bypass the error in uint_test1.sql by disabling the hash joins. > I am going to dig in and figure out why the hashjoin operation is broken. Well, the cause of that one would've been marking an operator as HASHES without providing a hash opclass to back it up. IIRC the test case involved ">"? That shouldn't even be marked HASHES anyway ... regards, tom lane