Обсуждение: BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'

The following bug has been logged on the website:

Bug reference:      8869
Logged by:          deadhead
Email address:      deadhead@goodfellow.it
PostgreSQL version: 9.3.2
Operating system:   rhel6
Description:

In the package ip4r93-1.05-3.rhel6.x86_64 there's a syntax error: the
LANGUAGE is specified in CAPITAL letter and this cause the error:

ERROR: language "C" does not exist

when executing:

$ psql -d nipap -f /usr/pgsql-9.3/share/contrib/ip4r.sql

To fix it is enough to launch:
$ sed -i -e "s/'C'/'c'/g" ip4r_.sql

regards

On Sat, Jan 18, 2014 at 11:08:59PM +0000, deadhead@goodfellow.it wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8869
> Logged by:          deadhead
> Email address:      deadhead@goodfellow.it
> PostgreSQL version: 9.3.2
> Operating system:   rhel6
> Description:
>
> In the package ip4r93-1.05-3.rhel6.x86_64 there's a syntax error: the
> LANGUAGE is specified in CAPITAL letter and this cause the error:
>
> ERROR: language "C" does not exist
>
> when executing:
>
> $ psql -d nipap -f /usr/pgsql-9.3/share/contrib/ip4r.sql
>
> To fix it is enough to launch:
> $ sed -i -e "s/'C'/'c'/g" ip4r_.sql

We don't maintain ip4r;  it is here:

    http://pgfoundry.org/projects/ip4r

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

Il 2014-01-21 22:37 Bruce Momjian ha scritto:
> We don't maintain ip4r;  it is here:
>
>     http://pgfoundry.org/projects/ip4r

Thank you Bruce for your answer, I was misleaded by the fact that it was
in your yum repo.

I'll open the bug there.


cheers

deadhead

Hi,

On Sat, 2014-01-18 at 23:08 +0000, deadhead@goodfellow.it wrote:
> PostgreSQL version: 9.3.2
> Operating system:   rhel6
> Description:
>
> In the package ip4r93-1.05-3.rhel6.x86_64 there's a syntax error: the
> LANGUAGE is specified in CAPITAL letter and this cause the error:
>
> ERROR: language "C" does not exist

Shame on me. I thought I already pushed 2.0 repos around September. Will
do in an hour. That version has the fix for that.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR