Skip to content

Instantly share code, notes, and snippets.

@jeffkreeftmeijer
Created December 13, 2011 17:24
Show Gist options
  • Save jeffkreeftmeijer/1473018 to your computer and use it in GitHub Desktop.
Save jeffkreeftmeijer/1473018 to your computer and use it in GitHub Desktop.
PGError: ERROR: syntax error at or near "IDENTITY" (ActiveRecord::StatementInvalid)
/Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec': PGError: ERROR: syntax error at or near "IDENTITY" (ActiveRecord::StatementInvalid)
LINE 1: TRUNCATE TABLE RESTART IDENTITY CASCADE;
^
: TRUNCATE TABLE RESTART IDENTITY CASCADE;
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in execute'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:244:in `block in log'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activesupport-3.1.3/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:239:in `log'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:591:in `execute'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/active_record/truncation.rb:89:in `truncate_tables'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/active_record/truncation.rb:122:in `block in clean'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/activerecord-3.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:508:in `disable_referential_integrity'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/active_record/truncation.rb:121:in `clean'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/base.rb:39:in `clean_with'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/configuration.rb:62:in `block in clean_with'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/configuration.rb:62:in `each'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/database_cleaner-0.7.0/lib/database_cleaner/configuration.rb:62:in `clean_with'
from /Users/jeff/opensource/travis-core/spec/support/active_record.rb:19:in `<top (required)>'
from /Users/jeff/opensource/travis-core/spec/json/pusher/build_finished_spec.rb:2:in `require'
from /Users/jeff/opensource/travis-core/spec/json/pusher/build_finished_spec.rb:2:in `<top (required)>'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/configuration.rb:459:in `load'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/configuration.rb:459:in `block in load_spec_files'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/configuration.rb:459:in `map'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/configuration.rb:459:in `load_spec_files'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/command_line.rb:18:in `run'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/runner.rb:80:in `run_in_process'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/runner.rb:69:in `run'
from /Users/jeff/.rvm/gems/ruby-1.9.3-preview1/gems/rspec-core-2.7.1/lib/rspec/core/runner.rb:10:in `block in autorun'
rake aborted!
@HashNuke
Copy link

HashNuke commented Jan 3, 2012

I just had this problem and I figured out it was because I had not migrated my test database before running the specs.

@readeharris
Copy link

Thanks @HashNuke, you just saved me a major headache. bundle exec rake db:test:prepare, everyone.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment