我根据以下教程使用我的Rails应用程序设置了PostGIS：http://www.daniel-azuma.com/blog/archives/69
当我尝试使用Guard运行我的测试时，出现以下错误： Exception encountered: #<ActiveRecord::StatementInvalid: PG::Error: ERROR: must be owner of relation spatial_ref_sys: ALTER TABLE "spatial_ref_sys" ENABLE TRIGGER ALL>
我已经将postgis架构的所有者更改为我的“普通”数据库用户 . 我也在使用数据库清理器进行测试 .
完整的回溯如下：
/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/rack-mini-profiler-0.1.18/lib/patches/sql_patches.rb:155:in exec'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/rack-mini-profiler-0.1.18/lib/patches/sql_patches.rb:155： inasync_exec'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.7/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in block执行'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:280:inblock在log'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.7/lib/active_support/notifications/instrumenter.rb:20:in instrument'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:275:inlog' /Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2 .7 / lib / active_record / connection_adapters / postgresql_adapter.rb：653：执行'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2 . 7 / lib / active_record / connection_adapters / postgresql_adapter.rb：530：disable_referential_integrity中的inensure'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2 . 7 / lib / active_record / connection_adapters / postgresql_adapter.rb：530：in disable_referential_integrity'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/database_cleaner-0.8.0 /lib/database_cleaner/active_record/truncation.rb:132:inclean'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/database_cleaner-0.8.0/lib /database_cleaner/base.rb:39:in clean_with'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/database_cleaner-0.8.0/lib/database_cleaner/ configuration.rb：62：clean_with中的inblock'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/database_cleaner-0.8.0/lib/databas e_cleaner / configuration.rb：62：在每个'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/database_cleaner-0.8.0/lib/database_cleaner/configuration中.rb：62：inclean_with'/ Users/OyoKooN/Projects/sos_medecins/spec/spec_helper.rb:50:in <top（required）>'/Users/OyoKooN/.rbenv/versions/1.9中的块（3级） . 3-p194 / lib / ruby / gems / 1.9.1 / gems / rspec-core-2.11.1 / lib / rspec / core / hooks.rb:23:ininstance_eval'/Users/OyoKooN/.rbenv/versions/1.9 . 3-p194 / lib / ruby / gems / 1.9.1 / gems / rspec-core-2.11.1 / lib / rspec / core / hooks.rb:23:in run'/Users/OyoKooN/.rbenv/versions/1.9 .3-p194 / lib / ruby / gems / 1.9.1 / gems / rspec-core-2.11.1 / lib / rspec / core / hooks.rb:72:inblock in run'/Users/OyoKooN/.rbenv/versions /1.9.3-p194/lib/ruby/gems/1.9.1/gems/rspec-core-2.11.1/lib/rspec/core/hooks.rb:72:in each'/Users/OyoKooN/.rbenv/ versions / 1.9.3-p194 / lib / ruby / gems / 1.9.1 / gems / rspec-core-2.11.1 / lib / rspec / core / hooks.rb:72:inrun'/Users/OyoKooN/.rbenv/版本/ 1.9.3-P194 / lib中/红宝石/宝石/ 1.9.1 /宝石/ rspec的核心-2.11.1 / lib目录/ rspec的/心病e / hooks.rb：424：在run_hook'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/rspec-core-2.11.1/lib/rspec /core/command_line.rb:27:inblock in run'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/rspec-core-2.11.1/lib /rspec/core/reporter.rb:34:in report'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/rspec-core-2.11.1/ lib / rspec / core / command_line.rb:25:inrun'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/ spork / test_framework / rspec.rb:11:in run_tests'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/spork /run_strategy/forking.rb:13:inblock in run'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/spork /forker.rb:21:in initialize'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/spork/ forker.rb:18:infork'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1 . 0.0rc3 / lib / spork / forker.rb:18:inin initialize'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/spork/run_strategy/forking.rb:9:innew'/ Users /OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/spork-1.0.0rc3/lib/spork/run_strategy/forking.rb:9:in run'/ Users / OyoKooN / .rbenv / versions / 1.9.3-p194 / lib / ruby / gems / 1.9.1 / gems / spork-1.0.0rc3 / lib / spork / server.rb:48:inrun'/Users/OyoKooN/.rbenv /versions/1.9.3-p194/lib/ruby/1.9.1/drb/drb.rb:1548:in perform_without_block'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/1.9 . 1 / drb / drb.rb：1508：inperform'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/drb/drb.rb:1586:in block（2 levels）在main_loop'/Users/OyoKooN/.rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/drb/drb.rb:1582:inloop'/Users/OyoKooN/.rbenv/versions/1.9.3 -p194 / lib / ruby / 1.9.1 / drb / drb.rb：1582：在“main_loop中的块”中
谢谢 .