X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9ECCA4759BD for ; Sun, 2 Mar 2003 22:27:08 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 05694-06 for ; Sun, 2 Mar 2003 22:27:06 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 6ADDC47595A for ; Sun, 2 Mar 2003 22:27:06 -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 h233R55u028328; Sun, 2 Mar 2003 22:27:05 -0500 (EST) To: Denis Zaitsev Cc: pgsql-sql@postgresql.org Subject: Re: default operator class (PostgreSQL's error?) In-reply-to: <20030303070705.C4208@natasha.zzz.zzz> References: <20030302142401.B4208@natasha.zzz.zzz> <18747.1046628100@sss.pgh.pa.us> <20030303070705.C4208@natasha.zzz.zzz> Comments: In-reply-to Denis Zaitsev message dated "Mon, 03 Mar 2003 07:07:05 +0500" Date: Sun, 02 Mar 2003 22:27:04 -0500 Message-ID: <28327.1046662024@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/55 X-Sequence-Number: 12095 Denis Zaitsev writes: > On Sun, Mar 02, 2003 at 01:01:40PM -0500, Tom Lane wrote: >> 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. Well, it works for me: for example, after building and installing the contrib/isbn_issn module, I can do opc=# create table isbn_t ( opc(# isbn isbn unique not null opc(# ); NOTICE: CREATE TABLE / UNIQUE will create implicit index 'isbn_t_isbn_key' for table 'isbn_t' CREATE TABLE I looked at the code and saw that indeed a default opclass must be visible in your search path to be found, so I suggest taking another look at that aspect. regards, tom lane