On N, 2005-09-15 at 13:41 -0700, Marc Munro wrote:
> Folks,
> I saw a suggestion in this list about adding an index to sl_log(log_xid)
> to speed up queries.  Can someone enlighten me on how to do this, I am
> getting the following error:
> 
> ERROR:  data type _cage2.xxid has no default operator class for access
> method "hash"
> 	You must specify an operator class for the index or define a
> 	default operator class for the data type
> 
> What do I need to specify for the opclass or access method or both?

look how it's done with the existing index (\d _xxe_cluster.sl_log_1)

original one:

"sl_log_1_idx1" btree (log_origin, log_xid _xxx_cluster.xxid_ops,
log_actionseq)

what needs to be added:
    "sl_log_1_idx2" btree (log_xid _xxx_cluster.xxid_ops)


-- 
Hannu Krosing <hannu at skype.net>