X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BFB6D474E42 for ; Sun, 2 Mar 2003 21:13:29 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 78220-07 for ; Sun, 2 Mar 2003 21:13:26 -0500 (EST) Received: from zzz.zzz (unknown [212.57.156.180]) by postgresql.org (Postfix) with ESMTP id EBBB247590C for ; Sun, 2 Mar 2003 21:13:24 -0500 (EST) Date: Mon, 3 Mar 2003 07:07:05 +0500 From: Denis Zaitsev To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: default operator class (PostgreSQL's error?) Message-ID: <20030303070705.C4208@natasha.zzz.zzz> References: <20030302142401.B4208@natasha.zzz.zzz> <18747.1046628100@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <18747.1046628100@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Sun, Mar 02, 2003 at 01:01:40PM -0500 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/54 X-Sequence-Number: 12094 On Sun, Mar 02, 2003 at 01:01:40PM -0500, Tom Lane wrote: > Denis Zaitsev writes: > > ERROR: data type name_t has no default operator class for access method "btree" > > Hm, that looks like it should work. You sure you marked the opclass > default? (Check its row in pg_opclass to see.) Yes, it is default. > Another possibility is that the opclass is in a schema that is not in > your search path --- I can't recall right now whether being in the > search path affects lookup of a default opclass. It is in a schema, and the schema is definitely in the search_path - it's pointed first there. More over, all the games described are being played in that schema. I already had a though about schemas and tried to explicitly qualify the type (name_t) of the attribute - nothing had changed...