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