ActiveRecord Migrations : Postgres : Strings as primary keys

Asked Feb 05 '13 at 22:21

Active Feb 09 '13 at 22:42

Viewed 44 times

I have tried several ways to add string as a primary key in rails. So far, this is what I have tried. Can someone please help find the solution.

class CreateClients < ActiveRecord::Migration
  def change
    create_table :clients, primary_key: :client_id, id: false do |t|
      t.string :client_id
      t.string :client_secret
      t.integer :app_id
    end
    add_index :clients, [:app_id, :client_id]
  end
end

class CreateClients < ActiveRecord::Migration
  def change
    create_table :clients, id: false do |t|
      t.string :client_id, primary: true
      t.string :client_secret
      t.integer :app_id
    end
    add_index :clients, [:app_id, :client_id]
  end
end

class CreateClients < ActiveRecord::Migration
  def change
    create_table :clients, id: false do |t|
      t.string :client_id, primary_key: true
      t.string :client_secret
      t.integer :app_id
    end
    add_index :clients, [:app_id, :client_id]
  end
end

edited Feb 09 '13 at 22:42

tereško

57,247
24
95
149

asked Feb 05 '13 at 22:21

Jason Waldrip

4,919
8
35
58

Two questions: 1) Why make an id column a string? 2) Why make a string a primary key instead of just unique? – weltschmerz Feb 06 '13 at 00:36
Have you looked at anything over here http://stackoverflow.com/q/750413/479863 ? – mu is too short Feb 06 '13 at 05:11

ActiveRecord Migrations : Postgres : Strings as primary keys

0 Answers0