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)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
