search for: uninstall_tsearch2

Displaying 1 result from an estimated 1 matches for "uninstall_tsearch2".

2007 Feb 03
1
Postgres + tsearch2, migrations, and unit testing
...o do it without overwriting any rails code or duplicating SQL or anything ugly, but didn''t manage to. The best I came up with is as follows: 1) In the migrations, perform all the tsearch2 related stuff for the table that requires full text indexing. This includes loading tsearch2.sql (and uninstall_tsearch2.sql in the down part), creating the tsvector column, the index on it, and the trigger that updates the tsvector column. 2) config.active_record.schema_format = :sql in the environment since schemas would puke at the tsvector column. 3) Copy all the inserts from the tsearch2.sql file and add it to...