postgresql-9.2.4-2: ossp-uuid module

postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

[-- Attachment #1: Type: text/plain, Size: 290 bytes --]

Hello again,

It would be useful to include "uuid-ossp" module in the default
distribution.  Here's a patch which does that.

The mailing list filters didn't like the "PACKAGE_BUGREPORT=..." line
with email address just before the patched line, so I had to set context
lines to 0.

Filipp


[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: postgresql-9.2.4-2-include-ossp-uuid.patch --]
[-- Type: text/x-patch, Size: 492 bytes --]

diff -U 0 /usr/src/postgresql-9.2.4-2.cygport.orig /usr/src/postgresql-9.2.4-2.cygport
--- /usr/src/postgresql-9.2.4-2.cygport.orig	2013-06-08 15:58:19.000000000 +0400
+++ /usr/src/postgresql-9.2.4-2.cygport	2013-07-26 15:14:11.356440700 +0400
@@ -15 +15 @@
-CYGCONF_ARGS="LDFLAGS=-Wl,-no-undefined --enable-nls --with-openssl --with-perl --with-python --with-ldap"
+CYGCONF_ARGS="LDFLAGS=-Wl,-no-undefined --enable-nls --with-openssl --with-perl --with-python --with-ldap --with-ossp-uuid"


[-- Attachment #3: Type: text/plain, Size: 218 bytes --]

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[marco atzeri]

Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
> Hello again,
>
> It would be useful to include "uuid-ossp" module in the default
> distribution.  Here's a patch which does that.
>
> The mailing list filters didn't like the "PACKAGE_BUGREPORT=..." line
> with email address just before the patched line, so I had to set context
> lines to 0.
>
> Filipp
>
>

noted. There is any additional dependency for that ?

Marco



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 26/07/2013 19:02 +0400, marco atzeri wrote:

> Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
>> Hello again,
>>
>> It would be useful to include "uuid-ossp" module in the default
>> distribution.  Here's a patch which does that.
>>
>> The mailing list filters didn't like the "PACKAGE_BUGREPORT=..." line
>> with email address just before the patched line, so I had to set context
>> lines to 0.
>>
>> Filipp
>>
>>
>
> noted. There is any additional dependency for that ?
>
> Marco

Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
Cygwin's libuuid1 or libuuid-devel modules installed.

The correct files are in my /usr/local so I remembered I built libuuid
specially for postgres.  I'll try to clarify what is required.

Filipp

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[marco atzeri]

Il 7/27/2013 9:25 AM, Filipp Gunbin ha scritto:
> On 26/07/2013 19:02 +0400, marco atzeri wrote:
>
>> Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
>>> Hello again,
>>>
>>> It would be useful to include "uuid-ossp" module in the default
>>> distribution.  Here's a patch which does that.
>>>
>>> The mailing list filters didn't like the "PACKAGE_BUGREPORT=..." line
>>> with email address just before the patched line, so I had to set context
>>> lines to 0.
>>>
>>> Filipp
>>>
>>>
>>
>> noted. There is any additional dependency for that ?
>>
>> Marco
>
> Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
> Cygwin's libuuid1 or libuuid-devel modules installed.

that is a problem. We need to understand why

>
> The correct files are in my /usr/local so I remembered I built libuuid
> specially for postgres.  I'll try to clarify what is required.
>
> Filipp
>

Marco

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 27/07/2013 09:57 +0200, marco atzeri wrote:

> Il 7/27/2013 9:25 AM, Filipp Gunbin ha scritto:
>> On 26/07/2013 19:02 +0400, marco atzeri wrote:
>>
>>> Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
>>>> Hello again,
>>>>
>>>> It would be useful to include "uuid-ossp" module in the default
>>>> distribution.  Here's a patch which does that.
>>>>
>>>> The mailing list filters didn't like the "PACKAGE_BUGREPORT=..." line
>>>> with email address just before the patched line, so I had to set context
>>>> lines to 0.
>>>>
>>>> Filipp
>>>>
>>>>
>>>
>>> noted. There is any additional dependency for that ?
>>>
>>> Marco
>>
>> Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
>> Cygwin's libuuid1 or libuuid-devel modules installed.
>
> that is a problem. We need to understand why

Returning to this old problem,

Currently postgres with ossp-uuid module (--with-ossp-uuid added to
CYGCONF_ARGS) builds with OSSP uuid library
(http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
included in util-linux.  I do not have enough skills to identify
problem, but it seems that function "uuid_export" is missing there.
Maybe the OSSP uuid library needs to be added as a separate package in
Cygwin?  It builds from original source with no patches.

>>
>> The correct files are in my /usr/local so I remembered I built libuuid
>> specially for postgres.  I'll try to clarify what is required.

That was OSSP uuid library in my /usr/local, clearly.

Filipp

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Marco Atzeri]

On 16/06/2014 19:04, Filipp Gunbin wrote:
> On 27/07/2013 09:57 +0200, marco atzeri wrote:
>

> Returning to this old problem,
>
> Currently postgres with ossp-uuid module (--with-ossp-uuid added to
> CYGCONF_ARGS) builds with OSSP uuid library
> (http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
> included in util-linux.  I do not have enough skills to identify
> problem, but it seems that function "uuid_export" is missing there.
> Maybe the OSSP uuid library needs to be added as a separate package in
> Cygwin?  It builds from original source with no patches.


It seems that uuid-ossp and util-linux uuid are two complete
not compatible libraries.

http://stackoverflow.com/questions/2566964/uuid-library-for-c

>>> The correct files are in my /usr/local so I remembered I built libuuid
>>> specially for postgres.  I'll try to clarify what is required.
>
> That was OSSP uuid library in my /usr/local, clearly.
>
> Filipp

Anyway, until someone add the uuid-ossp package on cygwin,
I will not add such dependency on postgres

Regards
Marco



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 16/06/2014 22:24 +0200, Marco Atzeri wrote:

> On 16/06/2014 19:04, Filipp Gunbin wrote:
>> On 27/07/2013 09:57 +0200, marco atzeri wrote:
>>
>> Currently postgres with ossp-uuid module (--with-ossp-uuid added to
>> CYGCONF_ARGS) builds with OSSP uuid library
>> (http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
>> included in util-linux.  I do not have enough skills to identify
>> problem, but it seems that function "uuid_export" is missing there.
>> Maybe the OSSP uuid library needs to be added as a separate package in
>> Cygwin?  It builds from original source with no patches.
>
>
> It seems that uuid-ossp and util-linux uuid are two complete
> not compatible libraries.

Yes.

> Anyway, until someone add the uuid-ossp package on cygwin,
> I will not add such dependency on postgres

I tried to prepare a package for uuid-ossp, but the result files produce
naming conflicts with libuuid and I don't know how to resolve them.  If
someone helps me, I'm willing to continue.

If someone just needs the uuid-ossp postgresql extension, here's the
ugly solution:

1. make && make install uuid-ossp library (it will install into
/usr/local)

2. add --with-ossp-uuid to CYGCONF_ARGS and build Cygwin postgresql

3. just copy uuid-related files from inst subdirectory to the postgres
directory

4. CREATE EXTENSION "uuid-ossp" now should work


Thanks Marco.

Filipp

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple