[postgis-users] raster2pgsql

[JamesH]

"raster2psql -?" Was using the executable file and following the
documentation so think the -o is causing the error.

"Make sure you not use python-based loader and try this:
raster2pgsql -s 27700 -I -C -M C:\Users\james\height_newcastle.img -F -t
64x64 public.height_newcastle > path/to/sql_file"

Thanks, have tried this and needed to add a few functions that didn't exist,
but have an error message of:
NOTICE:  CREATE TABLE will create implicit sequence
"height_newcastle_rid_seq" for serial column "height_newcastle.rid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"height_newcastle_pkey" for table "height_newcastle"
NOTICE:  Adding SRID constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding scale-X constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding scale-Y constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding blocksize-X constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding blocksize-Y constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding alignment constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding number of bands constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding pixel type constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Unable to get the pixel types of a sample raster
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 91 at assignment
PL/pgSQL function "addrasterconstraints" line 53 at RETURN
WARNING:  Unable to add constraint: 'pixel_types'.  Skipping
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding nodata value constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Unable to get the nodata values of a sample raster
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 94 at assignment
PL/pgSQL function "addrasterconstraints" line 53 at RETURN
WARNING:  Unable to add constraint: 'nodata_values'.  Skipping
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding out-of-database constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Unable to get the out-of-database bands of a sample raster
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 97 at assignment
PL/pgSQL function "addrasterconstraints" line 53 at RETURN
WARNING:  Unable to add constraint: 'out_db'.  Skipping
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
NOTICE:  Adding maximum extent constraint
CONTEXT:  PL/pgSQL function "addrasterconstraints" line 53 at RETURN
Query result with 1 row discarded.



ERROR:  VACUUM cannot be executed from a function or multi-command string

********** Error **********

ERROR: VACUUM cannot be executed from a function or multi-command string
SQL state: 25001

Any advice appreciated

Regards,
James

_______________________________________________
postgis-users mailing list
postgis-users at .refractions
http://postgis.refractions.net/mailman/listinfo/postgis-users



--
View this message in context: http://postgis.17.n6.nabble.com/raster2pgsql-tp4679577p4679696.html
Sent from the PostGIS - User mailing list archive at Nabble.com.