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.
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.