[postgis-devel] missing AddRasterColumn?

Christopher DeMars chdemars at ucdavis.edu
Wed Dec 14 14:09:44 PST 2011


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?

--Christopher



More information about the postgis-devel mailing list