I want to create a record with a manually-set custom ID, for instance:
Foo.create(:id => 8000, :name =>“bar”)
But when I try to do that, Rails ignores the id I pass and continues
to auto-increment the id in the table. So in other words the console
output is along the lines of:
What’s the best way around this? (By the way, after I insert this
record with the custom ID, I do want it to revert back to auto-
incrementing the id.)
What’s the best way around this? (By the way, after I insert this
record with the custom ID, I do want it to revert back to auto-
incrementing the id.)
Foo.create(:name => ‘bar’) do |foo|
foo.id = 8000
end
One caveat however that bit me last week doing something similar when
initializing some records in a new table. PostgreSQL has a sequence
created to support the auto-incrementing primary key (id) and I was
getting unique index errors when new (or editted!) records were being
saved and the sequence value was already a different record in the
table.
(My solution was to manually next values off each of the two sequences
until it would return a value that wasn’t already a key.)
output is along the lines of:
Foo.create(:name => ‘bar’) do |foo|
(My solution was to manually next values off each of the two sequences
until it would return a value that wasn’t already a key.)