Rails + Postgres migration - why am I receiving the error "PG::UndefinedFunction: ERROR: function gen_random_uuid() does not exist"? Rails + Postgres migration - why am I receiving the error "PG::UndefinedFunction: ERROR: function gen_random_uuid() does not exist"? postgresql postgresql

Rails + Postgres migration - why am I receiving the error "PG::UndefinedFunction: ERROR: function gen_random_uuid() does not exist"?


The issue was that the uuid-ossp extension was being blown away with the database each time I dropped the db as part of a reset and migration (e.g. rake db:drop db:create db:migrate).

The fix is to create a migration that's run before all other migrations which enables the relevant extension(s). Like so (db/migrate/0_enable_extensions.rb):

class EnableExtensions < ActiveRecord::Migration[5.1]  def change    enable_extension 'uuid-ossp'    enable_extension 'pgcrypto'  endend


Edge case answer:

Add the migration enabling the extension as stated above.

If you've previously had bigint id's and you're converting over to UUID, running rake db:reset db:migrate failed for me. Be sure to run rake db:drop db:create db:migrate as stated above!

If you get the error Environment data not found in the schema, run bin/rails db:environment:set RAILS_ENV=development.