Hello,
I just updated a small project I'm working on to RoR 2.0.2 from 1.2.4. I rely on a postgresql 8.0 database for storage and before the upgrade migrations and fixtures loading worked flawlessly. After the upgrade though, migrations work fine but fixtures just won't load on my dev environment giving me the following error (invoked with --trace):
** Invoke db:fixtures:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:fixtures:load rake aborted! RuntimeError: ERROR C42601 Msyntax error at or near "ENABLE" P25 Fscan.l L639 Ryyerror: ALTER TABLE schema_info ENABLE TRIGGER ALL;ALTER TABLE users ENABLE TRIGGER ALL;ALTER TABLE categories ENABLE TRIGGER ALL;ALTER TABLE entries ENABLE TRIGGER ALL /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/abstract_adapter.rb:150:in `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:407:in `execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:376:in `disable_referential_integrity' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ fixtures.rb:505:in `create_fixtures' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ base.rb:1198:in `silence' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ fixtures.rb:504:in `create_fixtures' /usr/local/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake: 157 /usr/local/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake: 156:in `each' /usr/local/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake: 156 /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `synchronize' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 /usr/local/bin/rake:19:in `load' /usr/local/bin/rake:19
I tried switching temporarily to a mysql database and the migrations and fixtures work well. Any ideas where the source of the problem could be?