Skip to content

Instantly share code, notes, and snippets.

@CodeOfficer
Forked from jeffkreeftmeijer/gist:1473018
Created March 26, 2012 14:28
Show Gist options
  • Save CodeOfficer/2205474 to your computer and use it in GitHub Desktop.
Save CodeOfficer/2205474 to your computer and use it in GitHub Desktop.
PGError: ERROR: syntax error at or near "IDENTITY" (ActiveRecord::StatementInvalid)
Loading ["spec"]
*****************************************************************
DEPRECATION WARNING: you are using a deprecated constant that will
be removed from a future version of RSpec.
/Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activesupport-3.2.1/lib/active_support/dependencies.rb:251:in `require'
* Rspec is deprecated.
* RSpec is the new top-level module in RSpec-2
*****************************************************************
*****************************************************************
DEPRECATION WARNING: you are using a deprecated constant that will
be removed from a future version of RSpec.
/Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activesupport-3.2.1/lib/active_support/dependencies.rb:245:in `load'
* Rspec is deprecated.
* RSpec is the new top-level module in RSpec-2
*****************************************************************
Run options: include {:focus=>true}
All examples were filtered out; ignoring {:focus=>true}
66 examples: 100% |==========================================| Time: 00:00:00
Finished in 0.07193 seconds
0 examples, 0 failures
/Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:640:in `async_exec': PG::Error: ERROR: syntax error at or near "IDENTITY" (ActiveRecord::StatementInvalid)
LINE 1: TRUNCATE TABLE RESTART IDENTITY CASCADE;
^
: TRUNCATE TABLE RESTART IDENTITY CASCADE;
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:640:in `block in execute'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activesupport-3.2.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:639:in `execute'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/active_record/truncation.rb:99:in `truncate_tables'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/active_record/truncation.rb:132:in `block in clean'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:513:in `disable_referential_integrity'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/active_record/truncation.rb:131:in `clean'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/base.rb:39:in `clean_with'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/configuration.rb:62:in `block in clean_with'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/configuration.rb:62:in `each'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/database_cleaner-0.7.1/lib/database_cleaner/configuration.rb:62:in `clean_with'
from /Users/codeofficer/work/world_brain/spec/support/database_cleaner.rb:4:in `block (2 levels) in <top (required)>'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:24:in `call'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:24:in `call'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:37:in `run_in'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:70:in `block in run_all'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:70:in `each'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:70:in `run_all'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/hooks.rb:368:in `run_hook'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/command_line.rb:27:in `block in run'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/reporter.rb:34:in `report'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/command_line.rb:25:in `run'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/runner.rb:80:in `run_in_process'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/runner.rb:69:in `run'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/rspec-core-2.8.0/lib/rspec/core/runner.rb:10:in `block in autorun'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:159:in `fork'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:159:in `fork_and_run'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:133:in `block in serve'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:105:in `loop'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:105:in `serve'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/gems/spin-0.4.3/bin/spin:256:in `<top (required)>'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/bin/spin:19:in `load'
from /Users/codeofficer/.rvm/gems/ruby-1.9.3-p125@worldbrain/bin/spin:19:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment