title: Sphinx + Postgres + uuid issues
body: <p>I have a <code>sql_query</code> for a source defined like so:</p>
  
  <pre><code> sql_query               = SELECT \
    criteria.item_uuid, \
    criteria.user_id, \
    criteria.color, \
    criteria.selection, \
    criteria.item_id, \
    home.state, \
    item.* \
    FROM criteria \
    INNER JOIN item USING (item_uuid) \
    INNER JOIN user_info home USING (user_id) \
    WHERE criteria.item_uuid IS NOT NULL
  </code></pre>
  
  <p>And then an index:</p>
  
  <pre><code> 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
   }
  </code></pre>
  
  <p>But when I run <code>indexer --rotate csearch</code> I get:</p>
  
  <pre><code> indexing index 'csearch'...
   WARNING: zero/NULL document_id, skipping
  </code></pre>
  
  <p>The idea is that the <code>item_uuid</code> column is the identifier I want, based on some combination of the other columns. The <code>item_uuid</code> column is a uuid type in postgres: perhaps sphinx does not support this? Anyway, any ideas here would be greatly appreciated.</p>