X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E1EB1475843 for ; Sun, 2 Mar 2003 13:01:51 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 27909-06 for ; Sun, 2 Mar 2003 13:01:50 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E929B474E61 for ; Sun, 2 Mar 2003 13:01:49 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h22I1e5u018748; Sun, 2 Mar 2003 13:01:41 -0500 (EST) To: Denis Zaitsev Cc: pgsql-sql@postgresql.org Subject: Re: default operator class (PostgreSQL's error?) In-reply-to: <20030302142401.B4208@natasha.zzz.zzz> References: <20030302142401.B4208@natasha.zzz.zzz> Comments: In-reply-to Denis Zaitsev message dated "Sun, 02 Mar 2003 14:24:01 +0500" Date: Sun, 02 Mar 2003 13:01:40 -0500 Message-ID: <18747.1046628100@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/50 X-Sequence-Number: 12090 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.) 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. regards, tom lane