Question about ip4r contrib and PostgreSQL 9.2 - Mailing list pgsql-general

Hi,

One of my project extensively uses ip4r addon ( http://pgfoundry.org/projects/ip4r/ ).

However, after migration of test environment to 9.2 that addon doesn't install anymore without manual fixes.
Trouble very simple:
addon use the LANGUAGE 'C' IMMUTABLE STRICT;  syntax
and now language names in PostgreSQL become case-sensitive.

So need replace all these strings with  LANGUAGE 'c' IMMUTABLE STRICT;


However, I have a question.
With addition of the range types in 9.2 could be the same functionality replaced with some custom build range type over cidr type or no?
I especially interested in gist index support for ip ranges.
Or it still better use the ip4r add on for such cases?


--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/

Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678

Skype: maxim.boguk
Jabber: maxim.boguk@gmail.com
МойКруг: http://mboguk.moikrug.ru/

"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."