[postgis-users] raster2pgsql

[Bborie Park]

I'm confused as to how you're getting the VACUUM error.  After looking 
at the loader code and testing out the loader using the same switches on 
a different raster, I can't get PostgreSQL to return that error.

By chance, are you making changes to the sql file outputted by the loader?

-bborie

On 04/02/2012 11:18 AM, Bborie Park wrote:
> 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