Do not specify an index name from shapefile and raster loaders
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 :/
Change History
(6)
Owner: |
changed from mcayland to strk
|
Status: |
new → assigned
|
Resolution: |
→ fixed
|
Status: |
assigned → closed
|
Resolution: |
fixed
|
Status: |
closed → reopened
|
Resolution: |
→ fixed
|
Status: |
reopened → closed
|
Keywords: |
history added
|
Milestone: |
PostGIS 2.2.0 → PostGIS 2.1.4
|
Version: |
trunk → 2.1.x
|
Interesting didn't even know that was an option.
BTW: We don't support 9.0 in 2.2. 2.1 was the last to support 9.0
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
http://postgis.net/docs/manual-dev/postgis_installation.html#install_requirements