Re: uuid extension not available

From: reiner peterke <zedaardv(at)gmail(dot)com>
To: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: uuid extension not available
Date: 2013-10-10 13:26:14
Message-ID: 825566A6-5792-4BC2-BBEA-993D5F09C73F@drizzle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

it sounds like you are missing the contrib code.

if you built from source you need to go to the contrib directory and run make, make install.

if you installed from a package you need to install the appropriate contrib package.

reiner

sent by smoke signals at great danger to my self.

On 10 okt 2013, at 14:42, Thara Vadakkeveedu <tharagv(at)yahoo(dot)com> wrote:

> Hi
> I have postgresql 9.2 installed on red hat linux 6.4 . I need to generate uuids using the uuid_generate_v4() function.
>
> select * from pg_available_extensions does not list this extension. The only extension that is available is plpgsql.
>
> I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder.
>
> What should I do next ? How can I can install this extension ?
>
> Thanks,
> Thara.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message avni 2013-10-10 20:09:17 ts_vector workaround for - No more than 256 positions per lexeme
Previous Message Thara Vadakkeveedu 2013-10-10 13:09:27 Re: uuid extension not available