I updated from RoR 4.0.4 to 4.1.1 to apply the latest security patch and it appears pg_search broke. Here's a error: PG::SyntaxError: ERROR: syntax error at or near "AS" LINE 1: ...sh', ''' ' ...

I'm using pg_search to search for Products: class Product include PgSearch pg_search_scope( :search_for, against: %i(sku), associated_against: { translations: [:name, :description] }, using...

I'm using pg_search for some text searching within my model. Among other attributes, I have an url field. Unfortuantelly Postgres doesn't seem to identify / and . as word separators, therefore I c...

I'm adding pgsearch to Rails 6 Action Text and am not sure the best technique for including pgsearch in the RichText model. I can't seem to monkey patch the model without breaking it. I do have it ...

I'm using Rails 4.2.4 with pg_search 1.0.5. class Advert < ActiveRecord::Base include PgSearch multisearchable :against => [:title, :body] end I would like to order the pg_search resul...

I'm creating a search inside a Rails app using the pg_search gem. However, one of the tables have a Text datatype field that it's content happens to be a little larger than usual. Now when I need ...

I have a migration: class AddGinIndexToContacts < ActiveRecord::Migration def up execute("CREATE INDEX contacts_search_idx ON contacts USING gin (first_name gin_trgm_ops, last_name gin_trgm_o...

Im using the gem pg_search to perform fulltext search on my postgres db. I've a scope like this: pg_search_scope :fulltext, against: [:firstname, :lastname, :middlename], using: { tsearch: { pre...

TO SUM UP : The module PgSearch provided by the Gem pg_search cannot be included, required or loaded on the staging environment (Rbenv, nginx, unicorn,capistrano), the problem happens on the web se...

I'd like to use ransack (via ActiveAdmin) to do full-text searches on a model. How can I get ransack to use pg_search for its query? I want to run queries that, among other query components, use ...

I'm using the pg_search gem in a Rails app to search against users - their bios and associated skill model. Users are developers, so their skills include things like "CSS", "C++", "C#", "Objective ...

This is my pg_search method: pg_search_scope :node_search, against: [:name, :user_id, :circa, :cached_tagged_user_names, :cached_user_tag_list], using: { tsearch: { any_word: true, dictionary: :...

I have a class Node that I have setup acts_as_taggable on, so I can add user_tags to any node. I also have a method on my Node model that will look up the actual User records for all the users in t...

I have implemented PgSearch on my Node model like so: include PgSearch pg_search_scope :node_search, against: [:name, :user_id, :circa], using: { tsearch: { any_word: true} }, :associated_agains...

I am building a Rails 3 application that will be hosted on Heroku. To implement full text search, these are the free alternatives that I have come across: Texticle acts_as_tsearch acts_as_index...

I am currently using Act_as_taggable_on for tagging and pg_search to search through my postgresql database on my Rails 3 application. How would I search through tags generated by the act_as_taggab...

Probem: When searching texts with multiple occurrences of words similar to the search query they get higher rank than texts with one exact match. Example: Say search query is "productivity", then ...

I'm trying to use pg_search to search through an associated model. When I run a search I get the error "PG::Error: ERROR: column plans.name does not exist". I'm running the search in the "plans" mo...

I have the following pg_search scope on my stories.rb model: pg_search_scope :with_text, :against => :title, :using => { :tsearch => { :dictionary => "english" }}, :associated_ag...

I'm following along on Ryan Bates' excellent tutorial on using the built-in PostgresQL full-text search in Rails. I'm currently using pg_search gem un-indexed no problem but I need to improve the p...

I am about to launch a beta site, and heroku looks like a great option. The only think that is getting me down is that the only search option is $20/mth for the Websolr add-on. I am sure that Webs...

In a Rails app I'm using the pg_search gem. When I run my RSpec suite I see many lines of: NOTICE: text-search query doesn't contain lexemes: "" LINE 1: ...e("pg_search_documents"."content"::text,...

I had pg_search working on my Rails 3.2.3 app using multisearch. Then I implemented the initializer provided by nertzy (author of pg_search) in this post.. Now when I run a search I get the followi...

I finally figured out how to implement pg_search's multisearch feature. But I'm having trouble making a usable search results page that displays links back to the various articles and faqs that con...

I am testing performance for PostgreSQL full text search (using pg_search gem) and solr (sunspot_solr gem). For 4 million records I am getting 13456 ms for Tsearch and 800 ms with SOLR (that is SO...