Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D774F63247B for ; Thu, 3 Jun 2010 14:35:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 73879-01 for ; Thu, 3 Jun 2010 17:35:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from oproxy1-pub.bluehost.com (oproxy1-pub.bluehost.com [66.147.249.253]) by mail.postgresql.org (Postfix) with SMTP id 85DE6632726 for ; Thu, 3 Jun 2010 14:35:10 -0300 (ADT) Received: (qmail 26758 invoked by uid 0); 3 Jun 2010 17:35:07 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by oproxy1.bluehost.com.bluehost.com with SMTP; 3 Jun 2010 17:35:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:From:Organization:To:Subject:Date:User-Agent:Cc:References:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User; b=TpgF7LiDoDa2fGp4mB5laiTue2IigHgDhswt3/OQ3tiC0NwxPI1SwLeutwDe04OYRcFwROMblYlovJT4QJfeNUGJf+EPzzf3zVjN7OWOXAxeYn/Rss6vuzN8k8sX/QY2; Received: from 173-164-51-9-colorado.hfc.comcastbusiness.net ([173.164.51.9] helo=[192.168.1.136]) by box498.bluehost.com with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1OKEFM-00028S-KA; Thu, 03 Jun 2010 11:30:25 -0600 From: Kevin Kempter Organization: Consistent State To: Tom Lane Subject: Re: pg_dump errors Date: Thu, 3 Jun 2010 11:30:31 -0600 User-Agent: KMail/1.9.4 Cc: pgsql-admin@postgresql.org References: <201006031108.38937.kevink@consistentstate.com> <6963.1275585528@sss.pgh.pa.us> In-Reply-To: <6963.1275585528@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201006031130.32033.kevink@consistentstate.com> X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 173.164.51.9 authed with kevink+consistentstate.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_PSBL=2.7 X-Spam-Level: X-Archive-Number: 201006/39 X-Sequence-Number: 34817 On Thursday 03 June 2010 11:18, Tom Lane wrote: > Kevin Kempter writes: > > pg_dump: Error message from server: ERROR: could not find hash function > > for hash operator 33639 > > Bizarre ... that command really oughtn't be invoking any non-builtin > operator, but the OID is too high for a builtin. What do you get from > "select 33639::regoperator"? > > regards, tom lane postgres=# select 33639::regoperator postgres-# ; regoperator ---------------- abc.=(oid,oid) (1 row)