Re: Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

The installer for windows for 64bit versions of postgresql doesn't
include ossp-uuid.sql.
Does anyone know where or how to get this?

Thanks
--
*Grace Batumbya*
Research Assistant | Seneca CDOT
Phone: 416-491-5050 x3548
cdot.senecac.on.ca <http://cdot.senecac.on.ca/>

Hi Grace-san.

Is this helpful to you?
http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/

Regards,
Hiroshi Saito

(2011/06/30 1:14), Grace Batumbya wrote:
> The installer for windows for 64bit versions of postgresql doesn't
> include ossp-uuid.sql.
> Does anyone know where or how to get this?
>
> Thanks
> --
> *Grace Batumbya*
> Research Assistant | Seneca CDOT
> Phone: 416-491-5050 x3548
> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>

Grace the ossp-uuid libraries have no make system to create a 64 bit
version and I guess there are some technical reasons with the compiler. 
You can run them on Linux 64 bit and Windows 32 bit only.  This is the
reason I'd like to see native UUID support built in to the datatype.

Best Regards

Michael Gould

"Grace Batumbya" <grace(dot)batumbya(at)senecac(dot)on(dot)ca> wrote:

> The installer for windows for 64bit versions of
>postgresql doesn't include ossp-uuid.sql.
>Does anyone know where or how to get this?
>
>Thanks
>--
>Grace Batumbya
>Research Assistant | Seneca CDOT
>Phone: 416-491-5050 x3548
><a href="http://cdot.senecac.on.ca/" target="_blank">cdot.senecac.on.ca</a>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax

Thanks... I didn't know that this had been done. Will be downloading
shortly, thanks

Mike Gould

"Hiroshi Saito" <hiroshi(at)winpg(dot)jp> wrote:
> Hi Grace-san.
>
> Is this helpful to you?
> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>
> Regards,
> Hiroshi Saito
>
> (2011/06/30 1:14), Grace Batumbya wrote:
>> The installer for windows for 64bit versions of postgresql doesn't
>> include ossp-uuid.sql.
>> Does anyone know where or how to get this?
>>
>> Thanks
>> --
>> *Grace Batumbya*
>> Research Assistant | Seneca CDOT
>> Phone: 416-491-5050 x3548
>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Thanks Hiroshi, that solved the problem.
If you do not mind, how did you go about to build ossp-uuid?

*Grace Batumbya*
Research Assistant | Seneca CDOT
Phone: 416-491-5050 x3548
cdot.senecac.on.ca <http://cdot.senecac.on.ca/>

On 6/29/2011 12:38 PM, Hiroshi Saito wrote:
> Hi Grace-san.
>
> Is this helpful to you?
> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>
> Regards,
> Hiroshi Saito
>
> (2011/06/30 1:14), Grace Batumbya wrote:
>> The installer for windows for 64bit versions of postgresql doesn't
>> include ossp-uuid.sql.
>> Does anyone know where or how to get this?
>>
>> Thanks
>> --
>> *Grace Batumbya*
>> Research Assistant | Seneca CDOT
>> Phone: 416-491-5050 x3548
>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>

Hi.

here is an excuse...
http://archives.postgresql.org/pgsql-general/2011-06/msg00738.php

Regard,
Hiroshi Saito

(2011/06/30 1:50), Grace Batumbya wrote:
> Thanks Hiroshi, that solved the problem.
> If you do not mind, how did you go about to build ossp-uuid?
>
> *Grace Batumbya*
> Research Assistant | Seneca CDOT
> Phone: 416-491-5050 x3548
> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>
> On 6/29/2011 12:38 PM, Hiroshi Saito wrote:
>> Hi Grace-san.
>>
>> Is this helpful to you?
>> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>>
>> Regards,
>> Hiroshi Saito
>>
>> (2011/06/30 1:14), Grace Batumbya wrote:
>>> The installer for windows for 64bit versions of postgresql doesn't
>>> include ossp-uuid.sql.
>>> Does anyone know where or how to get this?
>>>
>>> Thanks
>>> --
>>> *Grace Batumbya*
>>> Research Assistant | Seneca CDOT
>>> Phone: 416-491-5050 x3548
>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>

On 30/06/2011 12:42 AM, Michael Gould wrote:
>
> Grace the ossp-uuid libraries have no make system to create a 64 bit
> version and I guess there are some technical reasons with the
> compiler. You can run them on Linux 64 bit and Windows 32 bit only.
> This is the reason I'd like to see native UUID support built in to the
> datatype.
>
>
Anyone interested in this might want to start here:

http://msdn.microsoft.com/en-us/library/aa379205(v=vs.85).aspx
<http://msdn.microsoft.com/en-us/library/aa379205%28v=vs.85%29.aspx>
http://msdn.microsoft.com/en-us/library/aa379322(v=vs.85).aspx
<http://msdn.microsoft.com/en-us/library/aa379322%28v=vs.85%29.aspx>
http://msdn.microsoft.com/en-us/library/aa379358(v=vs.85).aspx
<http://msdn.microsoft.com/en-us/library/aa379358%28v=vs.85%29.aspx>

I don't use UUIDs and have way too much on my plate alread so I'm not
volunteering for this one.
--
Craig Ringer

On Thu, Jun 30, 2011 at 02:39, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 30/06/2011 12:42 AM, Michael Gould wrote:
>
> Grace the ossp-uuid libraries have no make system to create a 64 bit version
> and I guess there are some technical reasons with the compiler.  You can run
> them on Linux 64 bit and Windows 32 bit only.  This is the reason I'd like
> to see native UUID support built in to the datatype.
>
> Anyone interested in this might want to start here:
>
>   http://msdn.microsoft.com/en-us/library/aa379205(v=vs.85).aspx
>   http://msdn.microsoft.com/en-us/library/aa379322(v=vs.85).aspx
>   http://msdn.microsoft.com/en-us/library/aa379358(v=vs.85).aspx
>
> I don't use UUIDs and have way too much on my plate alread so I'm not
> volunteering for this one.

Yeha, should be fairly easy. Obviously, the module name shouldn't be
ossp-uuid in that case, but a completely separate module. But it
could/should provide a SQL-level compatible interface, of course...

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Hey Hiroshi,
Do you have a make file to compile for x64 windows?
May be if that is made available then ossp-uuid for x64 versions will
become standard.

*Grace Batumbya*
Research Assistant | Seneca CDOT
Phone: 416-491-5050 x3548
cdot.senecac.on.ca <http://cdot.senecac.on.ca/>

On 6/29/2011 1:02 PM, Hiroshi Saito wrote:
> Hi.
>
> here is an excuse...
> http://archives.postgresql.org/pgsql-general/2011-06/msg00738.php
>
> Regard,
> Hiroshi Saito
>
> (2011/06/30 1:50), Grace Batumbya wrote:
>> Thanks Hiroshi, that solved the problem.
>> If you do not mind, how did you go about to build ossp-uuid?
>>
>> *Grace Batumbya*
>> Research Assistant | Seneca CDOT
>> Phone: 416-491-5050 x3548
>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>
>> On 6/29/2011 12:38 PM, Hiroshi Saito wrote:
>>> Hi Grace-san.
>>>
>>> Is this helpful to you?
>>> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>>>
>>> Regards,
>>> Hiroshi Saito
>>>
>>> (2011/06/30 1:14), Grace Batumbya wrote:
>>>> The installer for windows for 64bit versions of postgresql doesn't
>>>> include ossp-uuid.sql.
>>>> Does anyone know where or how to get this?
>>>>
>>>> Thanks
>>>> --
>>>> *Grace Batumbya*
>>>> Research Assistant | Seneca CDOT
>>>> Phone: 416-491-5050 x3548
>>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>>
>

Hi Grace-san.

It is the same as windows.
http://winpg.jp/~saito/pg_work/OSSP_win32/

1. Deployment of tar.gz
2. apply the patch
3. configure and build by Linux or MinGW
4. config.h and win32.mak are set at the head of a source tree.
5. nmake -f win32.mak
It can be used by 32 bits and 64 bits.

Regards,
Hiroshi Saito

(2011/06/30 22:52), Grace Batumbya wrote:
> Hey Hiroshi,
> Do you have a make file to compile for x64 windows?
> May be if that is made available then ossp-uuid for x64 versions will
> become standard.
>
> *Grace Batumbya*
> Research Assistant | Seneca CDOT
> Phone: 416-491-5050 x3548
> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>
> On 6/29/2011 1:02 PM, Hiroshi Saito wrote:
>> Hi.
>>
>> here is an excuse...
>> http://archives.postgresql.org/pgsql-general/2011-06/msg00738.php
>>
>> Regard,
>> Hiroshi Saito
>>
>> (2011/06/30 1:50), Grace Batumbya wrote:
>>> Thanks Hiroshi, that solved the problem.
>>> If you do not mind, how did you go about to build ossp-uuid?
>>>
>>> *Grace Batumbya*
>>> Research Assistant | Seneca CDOT
>>> Phone: 416-491-5050 x3548
>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>>
>>> On 6/29/2011 12:38 PM, Hiroshi Saito wrote:
>>>> Hi Grace-san.
>>>>
>>>> Is this helpful to you?
>>>> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>>>>
>>>> Regards,
>>>> Hiroshi Saito
>>>>
>>>> (2011/06/30 1:14), Grace Batumbya wrote:
>>>>> The installer for windows for 64bit versions of postgresql doesn't
>>>>> include ossp-uuid.sql.
>>>>> Does anyone know where or how to get this?
>>>>>
>>>>> Thanks
>>>>> --
>>>>> *Grace Batumbya*
>>>>> Research Assistant | Seneca CDOT
>>>>> Phone: 416-491-5050 x3548
>>>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>>>
>>

Hiroshi,

I've what I believe your saying is the one that is in the contrib directory
now should work fine on Window 64

"Hiroshi Saito" <hiroshi(at)winpg(dot)jp> wrote:
> Hi Grace-san.
>
> It is the same as windows.
> http://winpg.jp/~saito/pg_work/OSSP_win32/
>
> 1. Deployment of tar.gz
> 2. apply the patch
> 3. configure and build by Linux or MinGW
> 4. config.h and win32.mak are set at the head of a source tree.
> 5. nmake -f win32.mak
> It can be used by 32 bits and 64 bits.
>
> Regards,
> Hiroshi Saito
>
> (2011/06/30 22:52), Grace Batumbya wrote:
>> Hey Hiroshi,
>> Do you have a make file to compile for x64 windows?
>> May be if that is made available then ossp-uuid for x64 versions will
>> become standard.
>>
>> *Grace Batumbya*
>> Research Assistant | Seneca CDOT
>> Phone: 416-491-5050 x3548
>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>
>> On 6/29/2011 1:02 PM, Hiroshi Saito wrote:
>>> Hi.
>>>
>>> here is an excuse...
>>> http://archives.postgresql.org/pgsql-general/2011-06/msg00738.php
>>>
>>> Regard,
>>> Hiroshi Saito
>>>
>>> (2011/06/30 1:50), Grace Batumbya wrote:
>>>> Thanks Hiroshi, that solved the problem.
>>>> If you do not mind, how did you go about to build ossp-uuid?
>>>>
>>>> *Grace Batumbya*
>>>> Research Assistant | Seneca CDOT
>>>> Phone: 416-491-5050 x3548
>>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>>>
>>>> On 6/29/2011 12:38 PM, Hiroshi Saito wrote:
>>>>> Hi Grace-san.
>>>>>
>>>>> Is this helpful to you?
>>>>> http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/
>>>>>
>>>>> Regards,
>>>>> Hiroshi Saito
>>>>>
>>>>> (2011/06/30 1:14), Grace Batumbya wrote:
>>>>>> The installer for windows for 64bit versions of postgresql doesn't
>>>>>> include ossp-uuid.sql.
>>>>>> Does anyone know where or how to get this?
>>>>>>
>>>>>> Thanks
>>>>>> --
>>>>>> *Grace Batumbya*
>>>>>> Research Assistant | Seneca CDOT
>>>>>> Phone: 416-491-5050 x3548
>>>>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/>
>>>>>
>>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax