No need to use -M on a new table. That's what's generating that VACUUM
error. As for everything else, that's just information about what
constraints could and could not be applied based upon the
characteristics of the table.
By the looks of it, some of the constraints could not be applied...
-bborie
On 04/02/2012 11:02 AM, JamesH wrote:
"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
--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
