Do not specify an index name from shapefile and raster loaders
|Reported by:||strk||Owned by:||strk|
|Keywords:||raster, shapefile, history||Cc:|
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 :/