Re: ERROR: index row size 2960 exceeds btree maximum

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ERROR: index row size 2960 exceeds btree maximum
Дата
Msg-id 20070531124525.GA4724@alvh.no-ip.org
обсуждение исходный текст
Ответ на ERROR: index row size 2960 exceeds btree maximum  ("Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>)
Список pgsql-hackers
Rodrigo Sakai wrote:

>   Basically, the data type is a composition of two timestamps, like:
> (timestamp, timestamp) and it is called 'period'. So, almost everything is
> fine. Data type is ok, operators are ok, but the index doesn't work fine.

Does type tinterval not suit you?  It is not very well documented but it
should work, or at least serve as a basis for developing your own types.

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Backend crash during explain
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Command tags in create/drop scripts