X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 399CE52AB2 for ; Fri, 15 Jul 2005 00:08:11 -0300 (ADT) 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 78071-10 for ; Fri, 15 Jul 2005 03:08:04 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id CC50852C34 for ; Fri, 15 Jul 2005 00:08:03 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j6F37r7x008231 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Jul 2005 21:07:55 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j6F37rsD024660; Thu, 14 Jul 2005 21:07:53 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j6F37rHn024659; Thu, 14 Jul 2005 21:07:53 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Jul 2005 21:07:52 -0600 From: Michael Fuhr To: "Chris White (cjwhite)" Cc: pgsql-admin@postgresql.org Subject: Re: Error message: cannot identify operator 184 Message-ID: <20050715030752.GA24612@winnie.fuhr.org> References: <3175C4C5F682C145B25808EB5737F16C62511A@xmb-sjc-21b.amer.cisco.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3175C4C5F682C145B25808EB5737F16C62511A@xmb-sjc-21b.amer.cisco.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/105 X-Sequence-Number: 18161 On Thu, Jul 14, 2005 at 03:38:19PM -0700, Chris White (cjwhite) wrote: > Sorry, the exact error message is > > could not identify operator 184. > > I saw it in the syslog error log. At the moment I can't tell what was > going on when it happened. What version of PostgreSQL are you running? I'll guess 7.4.x, as that's the only branch that appears to contain the phrase "could not identify operator" in an error message. The message appears in the _bt_getstrategynumber() function in access/nbtree/nbtutils.c; maybe somebody who's familiar with the btree code can say what's going on. What happens if you run the following query? SELECT 184::regprocedure; On my 7.4.8 systems the above query returns the following: regprocedure ---------------- oideq(oid,oid) (1 row) I'm wondering if the error means you're missing that function, which is used to compare oid values. But again, I'm not very familiar with the btree code, so maybe somebody else can comment. -- Michael Fuhr http://www.fuhr.org/~mfuhr/