Devise primary key error on postgresql, heroku, Rails 4

Question

It is really odd, I'm trying to create a new user by command line and I'm getting this error:

User.create :email => "pheewq+1@gmail.com", :password => '123456789', :password_confirmation => '123456789'

PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "users_pkey"
DETAIL:  Key (id)=(37) already exists.

Yana Agun Siswanto · Accepted Answer · 2020-03-06T07:24:03.970

24

Try This

$ heroku run rails console
irb(main)> ActiveRecord::Base.connection.tables.each { |t| ActiveRecord::Base.connection.reset_pk_sequence!(t) }

Source: https://stackoverflow.com/a/15108735/3034747

edited Mar 06 '20 at 07:24

answered Jul 25 '14 at 14:53

Yana Agun Siswanto

1,932
18
30

how do I do the same but with laravel php ? – Christopher Francisco May 12 '15 at 19:32
@ChristopherFrancisco If you have access to the database directly http://stackoverflow.com/questions/244243/how-to-reset-postgres-primary-key-sequence-when-it-falls-out-of-sync – Yana Agun Siswanto May 13 '15 at 02:35

Devise primary key error on postgresql, heroku, Rails 4

1 Answers1

Linked