Postgresql UUID primary key not defaulting to using uuid_generate_v4() in test environment...

[interhive]

I'm running Rails 4.0.0.rc1 and have a table that uses UUID as primary key:

class CreateWebLinks < ActiveRecord::Migration
  def change
    create_table :web_links, id: :uuid do |t|
      t.boolean     :active,      default: true
      t.string      :url,         null: false, default: "http://"
      t.string      :title,       null: false, default: ""
      t.string      :description
      t.timestamps
    end
  end
end

When running migrations, the development database sets the default value to use PG's uuid_generate_v4() function to create the ID within the database.

I have not been able to get the test database to perform similarly. The ID is created and is denoted as UUID. However, the default value of 'uuid_generate_v4()' is not set in the database.

I've tried blowing the test database away, rake test:prepare and rake db:migrate RAILS_ENV=test. Can't seem to get it working and tests are failing as a result.

[rafaelfranca]

Could you check 4-0-0 branch?

[interhive]

I've jumped on the 4-0-0 branch and I'm experiencing the same issue.

As an addition to my original issue, it appears that, when the table is created, the UUID 'id' field is not being set as the primary key within PostgreSQL, as it is in the development database.

Test Database (via pgadmin):

CREATE TABLE web_links
(
  id uuid NOT NULL,
  active boolean DEFAULT true,
  url character varying(255) NOT NULL DEFAULT 'http://'::character varying,
  title character varying(255) NOT NULL DEFAULT ''::character varying,
  description character varying(255),
  created_at timestamp without time zone,
  updated_at timestamp without time zone
)
WITH (
  OIDS=FALSE
);

Development database:

CREATE TABLE web_links
(
  id uuid NOT NULL DEFAULT uuid_generate_v4(),
  active boolean DEFAULT true,
  url character varying(255) NOT NULL DEFAULT 'http://'::character varying,
  title character varying(255) NOT NULL DEFAULT ''::character varying,
  description character varying(255),
  created_at timestamp without time zone,
  updated_at timestamp without time zone,
  CONSTRAINT web_links_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);

[tenderlove]

Can you post your schema.rb file? I can't seem to reproduce this issue (my test database gets the correct pk, etc):

[aaron@higgins lolwut]$ rake test
Run options: --seed 44124

# Running tests:



Finished tests in 0.001477s, 0.0000 tests/s, 0.0000 assertions/s.

0 tests, 0 assertions, 0 failures, 0 errors, 0 skips
[aaron@higgins lolwut]$ psql -h localhost omglol_test
SET
psql (9.2.2)
Type "help" for help.

omglol_test=# \d
             List of relations
 Schema |       Name        | Type  | Owner 
--------+-------------------+-------+-------
 public | schema_migrations | table | aaron
 public | web_links         | table | aaron
(2 rows)

omglol_test=# \d web_links
                                 Table "public.web_links"
   Column    |            Type             |                   Modifiers                   
-------------+-----------------------------+-----------------------------------------------
 id          | uuid                        | not null default uuid_generate_v4()
 active      | boolean                     | default true
 url         | character varying(255)      | not null default 'http://'::character varying
 title       | character varying(255)      | not null default ''::character varying
 description | character varying(255)      | 
 created_at  | timestamp without time zone | 
 updated_at  | timestamp without time zone | 
Indexes:
    "web_links_pkey" PRIMARY KEY, btree (id)

omglol_test=# 

[interhive]

This is what's in my schema file:

  create_table "web_links", id: false, force: true do |t|
    t.uuid     "id",                              null: false
    t.boolean  "active",      default: true
    t.string   "url",         default: "http://", null: false
    t.string   "title",       default: "",        null: false
    t.string   "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Again, I'm on 4-0-0 branch and am executing all commands through bundle exec to ensure that it's using the proper rails version.

Thanks!

[interhive]

Ok, here's the issue I'm seeing.

I dropped the databases, recreated them and, when I run 'rake db:migrate RAILS_ENV=test' it now includes the PostgreSQL extension required for UUID.

However, when I run 'rake test:prepare', the extension does not get added. So, it's half-way there.

I will use 'rake db:migrate RAILS_ENV=test' for now until the 'test:prepare' command works, as advertised.

Thanks!

[tenderlove]

Can you post the whole schema.rb file? I'm specifically looking for a line that is like enable_extension('uuid-ossp'). Also, if you run just "rake test" does it show up correctly?

[interhive]

Here's my full schema file and it's missing the enable_extension command required to create that extension. I was a bit befuddled that it wasn't in there but I thought it may be inferred from the migration files or something.

# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20130514003451) do

  create_table "admins", force: true do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: "", null: false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.integer  "sign_in_count",          default: 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.integer  "failed_attempts",        default: 0
    t.string   "unlock_token"
    t.datetime "locked_at"
    t.string   "authentication_token"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "admins", ["authentication_token"], name: "index_admins_on_authentication_token", unique: true, using: :btree
  add_index "admins", ["email"], name: "index_admins_on_email", unique: true, using: :btree
  add_index "admins", ["reset_password_token"], name: "index_admins_on_reset_password_token", unique: true, using: :btree
  add_index "admins", ["unlock_token"], name: "index_admins_on_unlock_token", unique: true, using: :btree

  create_table "algorithms", id: false, force: true do |t|
    t.uuid     "id",                                null: false
    t.string   "names",                                          array: true
    t.text     "description"
    t.integer  "description_filter_id", default: 0
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "hardware_types", force: true do |t|
    t.string   "name"
    t.boolean  "active"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "software_types", force: true do |t|
    t.string   "name"
    t.boolean  "active"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "text_filters", force: true do |t|
    t.string   "name",                                    null: false
    t.string   "processor",                               null: false
    t.boolean  "active",                  default: false
    t.integer  "failover_text_filter_id", default: 0
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "users", force: true do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: "", null: false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.string   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "unconfirmed_email"
    t.integer  "failed_attempts",        default: 0
    t.string   "unlock_token"
    t.datetime "locked_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "users", ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true, using: :btree
  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
  add_index "users", ["unlock_token"], name: "index_users_on_unlock_token", unique: true, using: :btree

  create_table "web_links", id: false, force: true do |t|
    t.uuid     "id",                              null: false
    t.boolean  "active",      default: true
    t.string   "url",         default: "http://", null: false
    t.string   "title",       default: "",        null: false
    t.string   "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

end

[interhive]

Also, here's the migration file where I create the extension in PG:

class EnablePostgresUuid < ActiveRecord::Migration
  def up
    execute 'create extension "uuid-ossp"'
  end
  def down
    execute 'drop extension "uuid-ossp"'
  end
end

[interhive]

I also tried this...

class EnablePostgresUuid < ActiveRecord::Migration
  def change
    enable_extension "uuid-ossp"
  end
end

It has the same effect on the development database but it's not creating the extension on the test database since it's not showing the enable_extension in the schema.rb.

Not sure what's going on.

[kennyj]

@interhive Do you use any postgresql version ?? Because Rails4.0.0.rc1 doesn't include #10504, we can't use enable_extension in Postgresql 9.1.

Now, in 4-0-stable and edge, PostgreSQL 9.1 has been supported about extensions .

[kennyj]

maybe related to #10451 and #10811 too.

[interhive]

@kennyj I am running PostgreSQL 9.1.3 -- it's bundled with Heroku's Postgres.app.