Rails - Dec 2007 - Test-db on SQLite: getting "index xx already exists" error

Hi all

I wanted to speed up my tests, so I changed my test environment from
MySQL to SQLite. I''m on OSX 10.4 so SQLite3 is already installed.

I changed the test env to the following:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX "name_unique" ON link_categories ("name")

But after running rake db:test:prepare I got the following error:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX "name_unique" ON link_categories ("name")

After changing back to MySQL everything worked again. What''s wrong
here?!

Thanks
Josh
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---