Question about ip4r contrib and PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От Maxim Boguk
Тема Question about ip4r contrib and PostgreSQL 9.2
Дата
Msg-id CAK-MWwSZwq6vyavkJa-F0VaR79CbqKiDjvfz+navWX-m6qcFVQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about ip4r contrib and PostgreSQL 9.2  (Merlin Moncure <mmoncure@gmail.com>)
Список 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."


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL, OLAP, and Large Clusters
Следующее
От: Chris Travers
Дата:
Сообщение: Re: PostgreSQL, OLAP, and Large Clusters