Denis Zaitsev <zzz(at)cd-club(dot)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