[postgis-devel] missing AddRasterColumn?

dustymugs dustymugs at gmail.com
Wed Dec 14 14:14:16 PST 2011


On 12/14/2011 02:09 PM, Christopher DeMars wrote:
> I'm trying to load a raster using raster2pgsql.py and I'm getting an
> error saying that AddRasterColumn doesn't exist:
>
> -----------------------------------
> BEGIN
> psql:tmp/ls20040502b10.sql:2: NOTICE:  CREATE TABLE will create
> implicit sequence "ls20040502b10_rid_seq" for serial column
> "ls20040502b10.rid"
> psql:tmp/ls20040502b10.sql:2: NOTICE:  CREATE TABLE / PRIMARY KEY will
> create implicit index "ls20040502b10_pkey" for table "ls20040502b10"
> CREATE TABLE
> psql:tmp/ls20040502b10.sql:3: ERROR:  function
> addrastercolumn(unknown, unknown, unknown, integer, text[], boolean,
> boolean, unknown, numeric, numeric, unknown, unknown, unknown) does
> not exist
> LINE 1: SELECT AddRasterColumn('public','ls20040502b10','rast',32610...
>                 ^
> HINT:  No function matches the given name and argument types. You
> might need to add explicit type casts.
> -----------------------------------
>
>
> Looking in /usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql,
> I don't see AddRasterColumn. Has this function been depreciated
> without updating raster2pgsql, did it get accidentally left out of the
> sql initialization scripts, or am I failing to load an additional
> initialization script?
>

You shouldn't be using raster2pgsql.py as it is no longer supported as 
of r8369.  Use raster2pgsql, a C-based raster loader.  The function sets 
for AddRasterColumn, DropRasterColumn and DropRasterTable were dropped 
in r8390.

-bborie



More information about the postgis-devel mailing list