Thanks Pat! On Thu, Apr 22, 2010 at 11:28 PM, Pat Allan <[email protected]>wrote:
> Hi Cássio > > Sorry I didn't get to your email sooner, but it's good to know you've got a > solution figured out. Hopefully the rest all goes smoothly! > > Cheers > > -- > Pat > > On 23/04/2010, at 7:04 AM, Cássio Marques wrote: > > > 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]<thinking-sphinx%[email protected]> > . > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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]<thinking-sphinx%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- 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.
