Re: Test Database fails to initialize

CapnRegex
2008-04-22T18:12:22Z

Yay, that worked, thanks..

just for the record, I added in

Rails::Initializer.run do |config|
  ... stuff that was already there ...
  config.active_record.schema_format = :sql
end



On Apr 22, 11:54 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> On 22 Apr 2008, at 18:27, CapnRegex wrote:
>
>
>
> > Model.connection.execute(''CREATE INDEX index_name ON
table_name
> > ( field1, field2, text_field(20) )'')
>
> > however, rails records that in the schema.rb as
>
> > add_index "table",
["field1","field2","text_field"], :name =>
> > "index_name"
>
> > which fails.
>
> > I don''t want to eliminate the index, as it gives me a
considerable
> > speed increase when looking for an exact match in the text_field..
>
> Switch from using the ruby schema dumper to the sql one (it''s an
> option inenvironment.rb)