Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUN9N-0001lf-Hu for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2013 20:48:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VUN9L-0003eG-QD for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2013 20:47:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUGdK-0002M2-Oo for pgsql-admin@postgresql.org; Thu, 10 Oct 2013 13:50:30 +0000 Received: from mail-la0-x22b.google.com ([2a00:1450:4010:c03::22b]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUGdD-00033H-QG for pgsql-admin@postgresql.org; Thu, 10 Oct 2013 13:50:30 +0000 Received: by mail-la0-f43.google.com with SMTP id ep20so2092510lab.16 for ; Thu, 10 Oct 2013 06:50:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=references:mime-version:in-reply-to:content-type :content-transfer-encoding:message-id:cc:from:subject:date:to; bh=j6YtaD3lGSTIzKzdm6SL7bENXPRHTOgIntdigE9T+4Q=; b=jEUavGf/kpIkjT/GNDC541oDCJHtXNGOmHtqpnPafQhpixRMOzdZyffNVAwciPkk0P ++XwQQqsppF5U22MQDU5ebjoGNK9yyFBBLFL/ksUu36fD4txgKX1HGxeIlaJAFaNe9a/ zRFkle0x8OHHNWYjMA8G7m25WQPCxXerdPTrMnBgYOXIrfB99GoPr5fXVXOtk6u/iWu6 Hncwe7Xa2bTv7gcKEBX6LhIF75HENpmYKbFu4OuCAacrfvr2JkPnQ2J+WGOzuH48hTWV AIIrfsHrmZFJZWqLLl7yLT5NHKDRJ9GVO+GAZntJew81bwomgbXe+boEnBVed3+pe5ro A7FA== X-Received: by 10.152.27.67 with SMTP id r3mr394222lag.50.1381413022904; Thu, 10 Oct 2013 06:50:22 -0700 (PDT) Received: from [10.222.192.211] (host-95-195-128-211.mobileonline.telia.com. [95.195.128.211]) by mx.google.com with ESMTPSA id js17sm40272947lab.5.1969.12.31.16.00.00 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 10 Oct 2013 06:50:21 -0700 (PDT) References: <1381408933.15336.YahooMailNeo@web125001.mail.ne1.yahoo.com> Mime-Version: 1.0 (1.0) In-Reply-To: <1381408933.15336.YahooMailNeo@web125001.mail.ne1.yahoo.com> Content-Type: multipart/alternative; boundary=Apple-Mail-72F65DE0-8FF0-47C0-923E-0A512353D408 Content-Transfer-Encoding: 7bit Message-Id: <825566A6-5792-4BC2-BBEA-993D5F09C73F@drizzle.com> Cc: "pgsql-admin@postgresql.org" X-Mailer: iPhone Mail (10B144) From: reiner peterke Subject: Re: uuid extension not available Date: Thu, 10 Oct 2013 15:26:14 +0200 To: Thara Vadakkeveedu X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail-72F65DE0-8FF0-47C0-923E-0A512353D408 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable it sounds like you are missing the contrib code.=20 if you built from source you need to go to the contrib directory and run mak= e, make install.=20 if you installed from a package you need to install the appropriate contrib p= ackage.=20 reiner sent by smoke signals at great danger to my self.=20 On 10 okt 2013, at 14:42, Thara Vadakkeveedu wrote: > Hi > I have postgresql 9.2 installed on red hat linux 6.4 . I need to generate u= uids using the uuid_generate_v4() function. > =20 > select * from pg_available_extensions does not list this extension. The on= ly extension that is available is plpgsql. > =20 > I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder.= > =20 > What should I do next ? How can I can install this extension ? > =20 > Thanks, > Thara. --Apple-Mail-72F65DE0-8FF0-47C0-923E-0A512353D408 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
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@yahoo.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.
--Apple-Mail-72F65DE0-8FF0-47C0-923E-0A512353D408--