[postgis-devel] [PostGIS] #1680: ERROR: index row requires 9960 bytes, maximum size is 8191

[PostGIS]

#1680: ERROR:  index row requires 9960 bytes, maximum size is 8191
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 When trying to create an index on a geography column I get this message:

 {{{
 strk=# create index idx_cshapeswdatevalid_geog on  cshapeswdatevalid
 (geog);
 ERROR:  index row requires 9960 bytes, maximum size is 8191
 }}}

 This is with PostgreSQL 8.4.10 on x86_64-pc-linux-gnu, 64bit
 and PostGIS 2.0.0beta2SVN r9419.

 The dataset is the one attached to ticket #1679 with the "geog" column
 just created using alter table and update.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1680>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.