BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'

Started by deadheadover 12 years ago4 messagesbugs
Jump to latest
#1deadhead
deadhead@goodfellow.it

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Bruce Momjian
bruce@momjian.us
In reply to: deadhead (#1)
Re: BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'

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. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#3deadhead
deadhead@goodfellow.it
In reply to: Bruce Momjian (#2)
Re: BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#4Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: deadhead (#1)
Re: BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'

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