Postgres Pro
Downloads
Home   >   mailing lists

Re: default operator class (PostgreSQL's error?) - Mailing list pgsql-sql

From Tom Lane
Subject Re: default operator class (PostgreSQL's error?)
Date
Msg-id 18747.1046628100@sss.pgh.pa.us
Whole thread Raw
In response to default operator class (PostgreSQL's error?)  (Denis Zaitsev <zzz@cd-club.ru>)
Responses Re: default operator class (PostgreSQL's error?)
Re: default operator class (PostgreSQL's error?)
List pgsql-sql
Tree view 
Denis Zaitsev <zzz@cd-club.ru> 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

pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: Dynamic SELECT condition
Next
From: Tomasz Myrta
Date:
Subject: Re: Beginner needs help