Skip site navigation (1) Skip section navigation (2)

Re: ERROR: index row size 2960 exceeds btree maximum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Rodrigo Sakai <rodrigo(dot)sakai(at)poli(dot)usp(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: index row size 2960 exceeds btree maximum
Date: 2007-05-31 12:45:25
Message-ID: 20070531124525.GA4724@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2007-05-31 12:56:00
Subject: Command tags in create/drop scripts
Previous:From: Zdenek KotalaDate: 2007-05-31 10:31:44
Subject: Re: Backend crash during explain

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group