Ok, I've solved this. The problem was that my PK was varchar and not integer (it's a legacy database). I've managed to change it to integer and now everything is working. Thanks!
2010/4/22 Cássio Marques <[email protected]> > Sorry about posting here again... but does anyone have some ideas about > this problem? > > thank you! > > 2010/4/15 Cássio Marques <[email protected]> > > Hello all, >> >> I'm trying to index a model in a new application but using a legacy >> database. My index definition is pretty simple: >> >> class Donor < ActiveRecord::Base >> define_index do >> indexes name, :sortable => true >> end >> end >> >> And I'm getting the following error: >> >> indexing index 'donor_core'... >> ERROR: index 'donor_core': sql_query_range: : range-query failed: ERROR: >> COALESCE types text and bigint cannot be matched >> LINE 1: SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1... >> ^ >> (DSN=pgsql://cmarques:*...@localhost:5432/csh-web_development). >> >> The name column in the donors table is a varchar(255). What is this >> bigint/text thing all about? >> >> I really don't know what's wrong here. Anyone? >> >> Thank you very much! >> >> -- >> Cássio Marques >> >> Blog: http://cassiomarques.wordpress.com >> >> If you're writing code and you're not testing it, the code is wrong. I >> don't care if it does the right thing, and people need to understand this. >> If it works by accident, you're still wrong. >> Bryan Liles - Ruby Hoedown 2008 >> > > > > -- > Cássio Marques > > Blog: http://cassiomarques.wordpress.com > > If you're writing code and you're not testing it, the code is wrong. I > don't care if it does the right thing, and people need to understand this. > If it works by accident, you're still wrong. > Bryan Liles - Ruby Hoedown 2008 > -- Cássio Marques Blog: http://cassiomarques.wordpress.com If you're writing code and you're not testing it, the code is wrong. I don't care if it does the right thing, and people need to understand this. If it works by accident, you're still wrong. Bryan Liles - Ruby Hoedown 2008 -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
