Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#2811 closed enhancement (fixed)

Do not specify an index name from shapefile and raster loaders

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.1.4
Component: utils/loader-dumper Version: 2.1.x
Keywords: raster, shapefile, history Cc:

Description

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)

comment:1 by robe, 10 years ago

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

comment:2 by strk, 10 years ago

Owner: changed from mcayland to strk
Status: newassigned

r12746 in trunk, r12747 in 2.1 branch

comment:3 by strk, 10 years ago

Resolution: fixed
Status: assignedclosed

comment:4 by strk, 10 years ago

Resolution: fixed
Status: closedreopened

The change introduced a bug in index creation, looking at it

comment:5 by strk, 10 years ago

Resolution: fixed
Status: reopenedclosed

Bug fixed with r12748 in 2.1 branch and r12749 with trunk. See #2820 to improve catching these errors in the future

comment:6 by strk, 10 years ago

Keywords: history added
Milestone: PostGIS 2.2.0PostGIS 2.1.4
Version: trunk2.1.x
Note: See TracTickets for help on using tickets.