Re: uuid-ossp for PostGres 8.4 running on Windows

[Michael Gould <mgould@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

Thanks, that worked perfectly.

Best Regards

Michael Gould

 

"Sachin Srivastava" <sachin.srivastava@xxxxxxxxxxxxxxxx> wrote:
 

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