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:
Foo.find(:last)
=> #<Foo id: 52, name: "foo">
Foo.create(:id => 8000, :name =>"bar")
=> #<Foo id: 53, name: "bar">
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.)