Rails auto-assigning id that already exists

by

I did this which solved the issue for me. 

ActiveRecord::Base.connection.tables.each do |t|
  ActiveRecord::Base.connection.reset_pk_sequence!(t)
end

I found the reset_pk_sequence! from this thread. http://www.ruby-forum.com/topic/64428

More Related Contents:

  1. Ignoring time zones altogether in Rails and PostgreSQL
  2. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  3. Can’t find the PostgreSQL client library (libpq)
  4. Repairing Postgresql after upgrading to OSX 10.7 Lion
  5. PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list
  6. Installing Postgres on windows for use with Ruby-on-Rails
  7. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  8. Rails: FATAL – Peer authentication failed for user (PG::Error)
  9. Adding foreign key to a rails model
  10. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  11. How can I rename a database column in a Ruby on Rails migration?
  12. How to get a random number in Ruby
  13. Why do routes with a dot in a parameter fail to match?
  14. When to use a “has_many :through” relation in Rails?
  15. rake db:schema:load vs. migrations
  16. Change from SQLite to PostgreSQL in a fresh Rails project
  17. ActiveRecord Find By Year, Day or Month on a Date field
  18. Rails 3: Multiple Select with has_many through associations
  19. What is the replacement for ActionController::Base.relative_url_root?
  20. Delete link sends “Get” instead of “Delete” in Rails 3 view
  21. f.error_messages in Rails 3.0
  22. Convert UTC to local time in Rails 3
  23. Scope with join on :has_many :through association
  24. Rails form_for :remote=>true is not calling js method
  25. Remote mysql database on Heroku app
  26. Rails Migrations: tried to change the type of column from string to integer
  27. How to implement bulk insert in Rails 3
  28. Sass import error in Rails 3 app – “File to import not found or unreadable: compass”
  29. How to integrate a Wrap Bootstrap theme into an Rails application?
  30. Rails 3 SSL routing redirects from https to http

Leave a Comment