Re: uuid-ossp for PostGres 8.4 running on Windows

Hello Michael,

In the EnterpriseDB installer, uuid-ossp contrib module is available but
not loaded/enabled by default. To enable uuid-ossp module simply run the
uuid-ossp.sql file ("share\contrib\uuid-ossp.sql").

This is something that i did:

psql.exe -U postgres -d postgres -f share\contrib\uuid-ossp.sql

Then from psql i fired the below query and got results,

SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');

Hope it helps.

On 07/18/2009 08:00 PM, Michael Gould wrote:
>
> Does anyone have a install or the proper files (not the source) to
> install the uuid-ossp contrib files for 8.4? The one thing that I
> think that EnterpriseDB install is lacking in is the contrib modules
> that have been in the previous postgres version installation. Is this
> something that is going to be added back into the EnterpriseDB installer?
>
> At any rate my main concern now is to get the uuid-ossp install for
> 8.4 so that I can use 8.4 for our new development.
>
> Best Regards
>
> ------------------------------------------------------------------------
> Michael Gould, Managing Partner
> Intermodal Software Solutions, LLC
> 904.226.0978
> 904.592.5250 fax

--
Regards,
Sachin Srivastava
www.enterprisedb.com