Ticket #1513 (closed defect: fixed)

Opened 16 months ago

Last modified 16 months ago

Index name missing in raster loader

Reported by: jorgearevalo Owned by: pracine
Priority: high Milestone: PostGIS 2.0.0
Component: raster Version: trunk
Keywords: raster, loader Cc: jorgearevalo

Description

When you specify -I option in the raster loader, the index name is not included. That causes an error. I think this function needs to be modified: http://trac.osgeo.org/postgis/browser/trunk/raster/loader/raster2pgsql.c#L900

Change History

Changed 16 months ago by dustymugs

Can you post the command line string that you used for raster2pgsql? Also, what version of PostgreSQL? The statement works fine in 9.0 and 9.1 as the database server will generate an appropriate name.

Changed 16 months ago by dustymugs

Ah. I see now. According to the PostgreSQL 8.4 docs, the "name" parameter for CREATE INDEX is required. As of 9.0, the "name" parameter is optional. Fix coming...

Changed 16 months ago by dustymugs

  • status changed from new to closed
  • resolution set to fixed

Fixed in r8975

Note: See TracTickets for help on using tickets.