CODEWITHSUNDEEP
postgresqlubuntuubuntu-13.04
Incerteza
Incerteza

Reputation: 34884

Can't use uuid and create an extension to use it

I want to use uuid in Postgresql 9.2 on Ubuntu 13. So when I tried to check whether is available or not, I did:

select uuid_generate_v4() as one;

And it gave me ERROR: function uuid_generate_v4() does not exist

Then I did CREATE EXTENSION "uuid-ossp";

ERROR:  could not open extension control file "/usr/share/postgresql/9.2/extension/uuid-ossp.control": No such file or directory

Well, what do I do next?

By the way, SELECT * FROM pg_available_extensions; returns plpsql (1.0) only.

Upvotes: 32

Views: 28188

Answers (4)

Anron Galaburda
Anron Galaburda

Reputation: 91

For you guys, who installed postgres using postgres rpm repo on Fedora or similar distro:

sudo dnf install postgresql-contrib

installs a package from default fedora repo, which conflicts with postgres, like:

/usr/pgsql-12/lib/libpq.so.5: no version information available (required by psql)

Right way is

sudo dnf install postgresql12-contrib

You can double check it during install, it has to be from pgdg12, same as postgresql-server

(you have insert your postgres version instead of '12')

Upvotes: 3

user456584
user456584

Reputation: 88845

For anyone using the asdf version manager with the asdf-postgres plugin, installing postgres versions as follows fixes this issue:

POSTGRES_EXTRA_CONFIGURE_OPTIONS=--with-uuid=e2fs asdf install postgres <VERSION>

Upvotes: 14

Mohamed Dernoun
Mohamed Dernoun

Reputation: 825

If you still get the error, try to run manually the two SQL files inside /usr/share/postgresql/9.X/extension/uuid-ossp*.sql into your database

Upvotes: 1

Peter Eisentraut
Peter Eisentraut

Reputation: 36729

The operating system package that contains the extension is not installed. To install it:

apt-get install postgresql-contrib-9.2

Upvotes: 44

Related Questions