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

PostGIS trac at osgeo.org
Mon Mar 12 09:38:33 PDT 2012


#1680: geography btree: 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:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 Yup, a GiST index works:
 {{{
 strk=# create index idx_cshapeswdatevalid_geog on  cshapeswdatevalid using
 gist (geog);
 CREATE INDEX
 }}}

 Well, I guess urgency reduces, but it's still a fact you can't create a
 btree on geography (what should it do is a different topic)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1680#comment:2>
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.


More information about the postgis-devel mailing list