facing a postgres error while running rake migration

Question

I am getting the following uuid error while running a rails app with postgres as backend. Can someone help me out with which dependency is needed.

 [root@localhost webapp]# rake db:migrate
    (in /root/mysite/webapp)
    ==  CreateContributors: migrating =============================================
    -- create_table(:contributors, {:id=>false})
       -> 0.0121s
    -- execute("alter table contributors add primary key (id)")
    NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "contributors_pkey" for table "contributors"
       -> 0.0797s
    -- execute("alter table contributors alter column id set default uuid_generate_v1()::varchar")
    rake aborted!
    An error has occurred, this and all later migrations canceled:

    PGError: ERROR:  function uuid_generate_v1() does not exist
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    : alter table contributors alter column id set default uuid_generate_v1()::varchar

mu is too short · Accepted Answer · 2012-02-20 07:08:27Z

1

The uuid_generate_v1() function is part of the uuid-ossp package and you have to install that into PostgreSQL before you can use it. You should have a file called uuid-ossp.sql in your PostgreSQL contrib directory. You can install the package with:

$ psql -d your_database < /the/path/to/uuid-ossp.sql

You'll probably want to run that as the database super user.

answered Feb 20, 2012 at 7:08

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hungry fish Over a year ago

thanks it worked now actually path was a problem it was in pgsql/contrib and i was looking in postgres folder

MissingHandle Over a year ago

The directory on ubuntu for this file seems to be: /usr/share/postgresql/[postgres-version]/extension

Collectives™ on Stack Overflow

facing a postgres error while running rake migration

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related