Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A2CAB64FCF9 for ; Tue, 9 Sep 2008 03:25:41 -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 86568-08 for ; Tue, 9 Sep 2008 03:25:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 8CB5064FCBF for ; Tue, 9 Sep 2008 03:25:32 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i26so434006wxd.28 for ; Mon, 08 Sep 2008 23:25:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=Wawo5s+XiyDsdxHmkSwsaZMdsMFUeATcIDXezgZd1Es=; b=v74xX/OV1e0mzo2TDcaEmt1CDiNvXjMOWvvOmHuB/h5uR/pvaF3IxeJUIhGSWB5z/A YZrjMhR9d6qn6WniubOpqKVygkBTHQF/ODBXgil1/i1Iq6iWq3zobFb2YcNXRANApWW+ d3xBTj4GM31LipW29RSJE4QKlaOLI1pwthhG0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=etj2Rd/+HNnX8FndzLISBHR29i4vhW4TBDdyNZlkJV+zqL1HTDteDeNqwoB/qavaQn FAgGl0xi++1hKzIQ5w6FDj2iVqjNxejnZPG1ZH5jcYczrv8qGSfnKtAloTjXRIgL8K8T 85HGfCQuSqQmn4HPemWmoZRewT2l1crV+l2Vo= Received: by 10.70.76.5 with SMTP id y5mr20243746wxa.68.1220941531376; Mon, 08 Sep 2008 23:25:31 -0700 (PDT) Received: by 10.70.49.17 with HTTP; Mon, 8 Sep 2008 23:25:31 -0700 (PDT) Message-ID: Date: Mon, 8 Sep 2008 23:25:31 -0700 From: "Ryan Bradetich" To: "Jaime Casanova" Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2] Cc: pgsql-patches In-Reply-To: <3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com> <3073cc9b0809062330o62fd74dax74b1730cedc0fbb9@mail.gmail.com> <3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com> 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/100 X-Sequence-Number: 7115 Hello Jaime, Thank you for the test cases! > mmm... i rebuild my test env and it works for me this time... until i > execute an analyze. I guess autovacuum executed an auto analyze last > time... I am able to duplicate the error you saw in the uint_test2.sql. 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. Just wanted to give you an update that I was able to reproduce the error with your test cases and I am working on a solution now. Thanks! - Ryan