[postgis-tickets] [PostGIS] #2811: Do not specify an index name from shapefile and raster loaders

[PostGIS]

#2811: Do not specify an index name from shapefile and raster loaders
-------------------------------+--------------------------------------------
 Reporter:  strk               |       Owner:  mcayland     
     Type:  enhancement        |      Status:  new          
 Priority:  medium             |   Milestone:  PostGIS 2.2.0
Component:  loader/dumper      |     Version:  trunk        
 Keywords:  raster, shapefile  |  
-------------------------------+--------------------------------------------
 Starting with PostgreSQL 9.0 (the minimum supported by PostGIS 2.2.0)
 there's no need to specify an index name on CREATE INDEX:
 http://www.postgresql.org/docs/9.0/interactive/sql-createindex.html

 Omitting the name makes PostgreSQL choose a suitable name for you.

 I was hit by forcing a name getting an exception after waiting for 40
 minutes for an import. The explicitly mentioned name of that index was
 already in use :/

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