Re: ERROR: index row size 2960 exceeds btree maximum - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: ERROR: index row size 2960 exceeds btree maximum
Date
Msg-id 20070531124525.GA4724@alvh.no-ip.org
Whole thread Raw
In response to ERROR: index row size 2960 exceeds btree maximum  ("Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>)
List 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 by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Backend crash during explain
Next
From: Peter Eisentraut
Date:
Subject: Command tags in create/drop scripts