Denis Zaitsev <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])