My website uses PostgreSQL and its full-text search. For that to work, I need to execute some configuration queries in order to configure some full-text search extensions. This is what I have written in a migration file to configure the development database: class ConfigurePostgresql < ActiveRecord::Migration def up execute("CREATE EXTENSION unaccent;") execute("ALTER TEXT SEARCH DICTIONARY unaccent (RULES='unaccent');") execute("CREATE TEXT SEARCH CONFIGURATION es ( COPY = spanish );") execute("ALTER TEXT SEARCH CONFIGURATION es ALTER MAPPING FOR hword, hword_part, word WITH unaccent, spanish_stem;") end end This works perfectly in develpment. Now I want to run some search tests, but when I execute my functional tests, I get an error saying that the extension is not configured: ActiveRecord::StatementInvalid: PG::Error: ERROR: function unaccent(text) does not exist Why is not it creating the extension? I have executed rake db:test:prepare
on 2012-10-24 12:50
on 2012-10-24 13:07
I have noticed that those execute lines are not included in my schema.rb. When I copy them inside the schema.rb, then all tests run correctly. Is there some way to make this work well without having to copy the executes everytime I make a migration?
on 2012-10-24 13:12
On Wed, Oct 24, 2012 at 6:49 PM, David M <email@example.com> wrote: > execute("ALTER TEXT SEARCH DICTIONARY unaccent (RULES='unaccent');") > tests, I get an error saying that the extension is not configured: > > ActiveRecord::StatementInvalid: PG::Error: ERROR: function unaccent(text) does not exist > > Why is not it creating the extension? I have executed rake db:test:prepare > i think rake db:test:prepare uses schema.rb to create the test database. since you added raw sql, this is not added to schema.rb. you should use the sql format of schema.rb. more info here http://guides.rubyonrails.org/migrations.html#sche... > > --
on 2012-10-24 13:31
Thanks jim, that solved the problem. El mircoles, 24 de octubre de 2012 13:11:57 UTC+2, jim escribi: