postgresql - Sphinx + Postgres + uuid issues -

i have sql_query source defined so:

 sql_query               = select \   criteria.item_uuid, \   criteria.user_id, \   criteria.color, \   criteria.selection, \   criteria.item_id, \   home.state, \   item.* \   criteria \   inner join item using (item_uuid) \   inner join user_info home using (user_id) \   criteria.item_uuid not null 

and index:

 index csearch {   source                  = csearch   path                    = /usr/local/sphinx/var/data/csearch   docinfo                 = extern   enable_star             = 1   min_prefix_len          = 0   min_infix_len           = 0   morphology              = stem_en  } 

but when run indexer --rotate csearch get:

 indexing index 'csearch'...  warning: zero/null document_id, skipping 

the idea item_uuid column identifier want, based on combination of other columns. item_uuid column uuid type in postgres: perhaps sphinx not support this? anyway, ideas here appreciated.

read docs, document_id must unique unsigned non-zero integers.

http://www.sphx.org/docs/manual-1.10.html#data-restrictions

you try using select row_number(), uuid, etc...