Using Rails, how can I set my primary key to not be an integer-typed column?

by

Unfortunately, I’ve determined it’s not possible to do it without using execute.

Why it doesn’t work

By examining the ActiveRecord source, we can find the code for create_table:

In schema_statements.rb:

def create_table(table_name, options={})
  ...
  table_definition.primary_key(options[:primary_key] || Base.get_primary_key(table_name.to_s.singularize)) unless options[:id] == false
  ...
end

So we can see that when you try to specify a primary key in the create_table options, it creates a primary key with that specified name (or, if none is specified, id). It does this by calling the same method you can use inside a table definition block: primary_key.

In schema_statements.rb:

def primary_key(name)
  column(name, :primary_key)
end

This just creates a column with the specified name of type :primary_key. This is set to the following in the standard database adapters:

PostgreSQL: "serial primary key"
MySQL: "int(11) DEFAULT NULL auto_increment PRIMARY KEY"
SQLite: "INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL"

The workaround

Since we’re stuck with these as the primary key types, we have to use execute to create a primary key that is not an integer (PostgreSQL’s serial is an integer using a sequence):

create_table :employees, {:id => false} do |t|
  t.string :emp_id
  t.string :first_name
  t.string :last_name
end
execute "ALTER TABLE employees ADD PRIMARY KEY (emp_id);"

And as Sean McCleary mentioned, your ActiveRecord model should set the primary key using set_primary_key:

class Employee < ActiveRecord::Base
  set_primary_key :emp_id
  ...
end

More Related Contents:

  1. Using Rails Migration on different database than standard “production” or “development”
  2. Difference between rake db:migrate db:reset and db:schema:load
  3. Rails :include vs. :joins
  4. PG::ConnectionBad – could not connect to server: Connection refused
  5. Why can you not have a foreign key in a polymorphic association?
  6. How can I rename a database column in a Ruby on Rails migration?
  7. Postgres could not connect to server
  8. Composite primary keys versus unique object ID field
  9. PG undefinedtable error relation users does not exist
  10. rake db:schema:load vs. migrations
  11. Alias for column names in Rails
  12. Change from SQLite to PostgreSQL in a fresh Rails project
  13. Multiple databases in Rails
  14. Rails migration for change column
  15. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  16. What is the best way to seed a database in Rails?
  17. Connecting to multiple databases in ruby on rails
  18. Cannot add a NOT NULL column with default value NULL in Sqlite3
  19. How do I handle too long index names in a Ruby on Rails ActiveRecord migration?
  20. Rails migration for has_and_belongs_to_many join table
  21. A migration to add unique constraint to a combination of columns
  22. How can I rollback a specific migration?
  23. How do I set up the database.yml file in Rails?
  24. Run a single migration file
  25. Rails 3 migrations: Adding reference column?
  26. How to implement Active Record inheritance in Ruby on Rails?
  27. Adding foreign key to a rails model
  28. How do I avoid a race condition in my Rails app?
  29. Rails: store translations in database
  30. How do I add some inserts in rails migration?

Leave a Comment