Thread: PostgreSQL 8.2.0 and ip4r?

PostgreSQL 8.2.0 and ip4r?

From
Harald Fuchs
Date:
I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
Has anyone managed to fix that?

Re: PostgreSQL 8.2.0 and ip4r?

From
Martijn van Oosterhout
Date:
On Sat, Dec 09, 2006 at 12:10:16PM +0100, Harald Fuchs wrote:
> I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
> stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
> Has anyone managed to fix that?

What exactly is the problem? Does it not compile or something?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

Re: PostgreSQL 8.2.0 and ip4r?

From
Harald Fuchs
Date:
In article <20061209112944.GB1528@svana.org>,
Martijn van Oosterhout <kleptog@svana.org> writes:

> On Sat, Dec 09, 2006 at 12:10:16PM +0100, Harald Fuchs wrote:
>> I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
>> stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
>> Has anyone managed to fix that?

> What exactly is the problem? Does it not compile or something?

Yes:

$ make USE_PGXS=1
sed 's,MODULE_PATHNAME,$libdir/ip4r,g' ip4r.sql.in >ip4r.sql
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing-fpic -DIP4R_PGVER=8002000 -I. -I/usr/include/postgresql/server -I/usr/include/postgresql/internal
-D_GNU_SOURCE  -c -o ip4r.o ip4r.c 
ip4r.c: In function 'ip4_cast_to_cidr':
ip4r.c:627: error: 'struct <anonymous>' has no member named 'type'
ip4r.c: In function 'ip4r_cast_from_cidr':
ip4r.c:967: error: 'struct <anonymous>' has no member named 'type'
ip4r.c: In function 'ip4r_cast_to_cidr':
ip4r.c:1004: error: 'struct <anonymous>' has no member named 'type'
make: *** [ip4r.o] Error 1
$

Re: PostgreSQL 8.2.0 and ip4r?

From
Martijn van Oosterhout
Date:
On Sat, Dec 09, 2006 at 12:48:34PM +0100, Harald Fuchs wrote:
> > What exactly is the problem? Does it not compile or something?
>
> Yes:
>
> $ make USE_PGXS=1
> sed 's,MODULE_PATHNAME,$libdir/ip4r,g' ip4r.sql.in >ip4r.sql
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing-fpic -DIP4R_PGVER=8002000 -I. -I/usr/include/postgresql/server -I/usr/include/postgresql/internal
-D_GNU_SOURCE  -c -o ip4r.o ip4r.c 
> ip4r.c: In function 'ip4_cast_to_cidr':
> ip4r.c:627: error: 'struct <anonymous>' has no member named 'type'
> ip4r.c: In function 'ip4r_cast_from_cidr':
> ip4r.c:967: error: 'struct <anonymous>' has no member named 'type'
> ip4r.c: In function 'ip4r_cast_to_cidr':
> ip4r.c:1004: error: 'struct <anonymous>' has no member named 'type'
> make: *** [ip4r.o] Error 1

Looking at CVS, line 967 is a blank line, so I have to ask what version
you're compiling. I notice the CVS tree got some patches two months ago
for 8.2 but there has been no release since then. Perhaps you should
try the latest CVS version?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

Re: PostgreSQL 8.2.0 and ip4r?

From
Harald Fuchs
Date:
In article <20061209115851.GC1528@svana.org>,
Martijn van Oosterhout <kleptog@svana.org> writes:

> Looking at CVS, line 967 is a blank line, so I have to ask what version
> you're compiling. I notice the CVS tree got some patches two months ago
> for 8.2 but there has been no release since then. Perhaps you should
> try the latest CVS version?

This was it!

I assumed that the ip4r-1.0.tgz presented on the PgFoundry site was
the most recent version.  After getting the five files via CVS,
everything seems to work now.

Thanks for your help!

Re: PostgreSQL 8.2.0 and ip4r?

From
Martijn van Oosterhout
Date:
On Sat, Dec 09, 2006 at 02:48:15PM +0100, Harald Fuchs wrote:
> This was it!
>
> I assumed that the ip4r-1.0.tgz presented on the PgFoundry site was
> the most recent version.  After getting the five files via CVS,
> everything seems to work now.

It might be an idea to either file a bug, or email the authors to put
up a new version.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment