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?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---