latest update_index method

gistfile1.rb

  def self.update_index(observer_search_data)
    # Would be nice to use AR here but not sure how to execut Postgres functions
    # when inserting data like this.
    rows = Post.exec_sql_row_count("UPDATE #{observer_search_data.table_name} SET search_data = TO_TSVECTOR('english', ?) WHERE #{observer_search_data.foreign_key} = ?", observer_search_data.search_data, observer_search_data.id)
    if rows == 0
      Post.exec_sql("INSERT INTO #{observer_search_data.table_name} (#{observer_search_data.foreign_key}, search_data) VALUES (?, TO_TSVECTOR('english', ?))", observer_search_data.id, observer_search_data.search_data)
    end
  rescue
    # don't allow concurrency to mess up saving a post
  end