[postgis-devel] [PostGIS] #1009: lookup_tables_2010.sql - Index creation error

PostGIS trac at osgeo.org
Thu Jun 9 08:49:38 PDT 2011


#1009: lookup_tables_2010.sql - Index creation error
----------------------------+-----------------------------------------------
 Reporter:  egouge          |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  low             |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Line 950 in tables/lookup_tables_2010.sql is creating an index on the
 faces table which at this point doesn't exist.

 CREATE INDEX tiger_state_the_geom_gist ON faces USING gist(the_geom);
 should probably be:
 CREATE INDEX tiger_state_the_geom_gist ON state USING gist(the_geom);

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1009>
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