Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A517A6323AF for ; Thu, 3 Jun 2010 17:36:18 -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 36093-04 for ; Thu, 3 Jun 2010 20:36:10 +0000 (UTC) X-Greylist: delayed 00:06:38.770426 by SQLgrey-1.7.6 Received: from oproxy3-pub.bluehost.com (oproxy3-pub.bluehost.com [69.89.21.8]) by mail.postgresql.org (Postfix) with SMTP id 3BD7363248E for ; Thu, 3 Jun 2010 17:36:11 -0300 (ADT) Received: (qmail 32299 invoked by uid 0); 3 Jun 2010 20:29:30 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by oproxy3.bluehost.com with SMTP; 3 Jun 2010 20:29:30 -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=doeOR0uTZQH7GFTjE5HhR5+KOvPxZyEj5jyLSi3JwDefEiuijTAQ1qTPuGZLJ/ycOc+Q5H/KqSiRvXdp7hXuQ7bRcZFlD6D8K/Ux4SJzE16U/+lKHh7q1ZoUaCghHsbZ; 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 1OKH2f-0001UC-St; Thu, 03 Jun 2010 14:29:30 -0600 From: Kevin Kempter Organization: Consistent State To: pgsql-admin@postgresql.org Subject: Re: pg_dump errors Date: Thu, 3 Jun 2010 14:29:39 -0600 User-Agent: KMail/1.9.4 Cc: Tom Lane References: <201006031108.38937.kevink@consistentstate.com> <201006031130.32033.kevink@consistentstate.com> <7442.1275587101@sss.pgh.pa.us> In-Reply-To: <7442.1275587101@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201006031429.39396.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.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201006/42 X-Sequence-Number: 34820 On Thursday 03 June 2010 11:45, Tom Lane wrote: > Kevin Kempter writes: > > On Thursday 03 June 2010 11:18, Tom Lane wrote: > >> 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"? > > > > postgres=# select 33639::regoperator > > postgres-# ; > > regoperator > > ---------------- > > abc.=(oid,oid) > > (1 row) > > So where did that come from, and why is it defined incorrectly? > (Evidently it's marked oprcanhash but there is no associated hash > opclass.) I can hardly see a reason to define your own oid equality > operator, much less a wrong one ... > > regards, tom lane I dont know where it came from. I havent intentionally defined any classes, or anything like this. However this is a dev instance so maybe something went wrong at some point.