[postgis-users] index tablespace handing in raster2psql broken

Kim Bisgaard kib at dmi.dk
Wed Jul 25 06:29:33 PDT 2012


Just did -- ticket #1932.

On 2012-07-25 15:15, Sandro Santilli wrote:
> Thanks for the contribution Kim, the best way to report bugs would
> be on the bug tracker, can you do that ?
>
> http://trac.osgeo.org/postgis/login
> (just hit Cancel for instructions on how to get an OSGeo id).
>
> --strk;
>
> On Wed, Jul 25, 2012 at 02:36:13PM +0200, Kim Bisgaard wrote:
>> Hi,
>>
>> I tried using "-X" option for raster2psql but got a PostgreSQL syntax error.
>>
>> raster2psql in version 2.0.1 outputs the following SQL:
>> CREATE TABLE "2mt_20120802_00" ("rid" serial PRIMARY KEY,"rast" raster)
>> USING INDEX TABLESPACE "data"
>> TABLESPACE "data";
>>
>> while the correct PostgreSQL 9.1 syntax is:
>> CREATE TABLE "2mt_20120802_00" ("rid" serial PRIMARY KEY USING INDEX TABLESPACE "data","rast" raster)
>> TABLESPACE "data";
>>
>> where as it can be changed to use correct PostgreSQL syntax by changing code in raster/loader/raster2psql.c line 899 to:
>>
>> sprintf(sql, "CREATE TABLE %s%s (\"rid\" serial PRIMARY KEY%s%s,%s raster%s)%s%s;",
>> (schema != NULL ? schema : ""),
>> table,
>> (idx_tablespace != NULL ? " USING INDEX TABLESPACE " : ""),
>> (idx_tablespace != NULL ? idx_tablespace : ""),
>> column,
>> (file_column ? ",\"filename\" text" : ""),
>> (tablespace != NULL ? " TABLESPACE " : ""),
>> (tablespace != NULL ? tablespace : "")
>> );
>>


-- 
Kim Bisgaard

Application Development Division     Phone: +45 3915 7562 (direct)
Danish Meteorological Institute      Fax: +45 3915 7460 (division)




More information about the postgis-users mailing list