[postgis-users] raster2pgsql

[Bborie Park]

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

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu