[postgis-users] error when adding raster-support to my postgisDB - rtpostgis.sql $1 declared as CONSTANT - while compiling plpgsql addrastercolumn

[Jorge Arévalo]

On Thu, Sep 1, 2011 at 4:45 PM, Bborie Park <bkpark at ucdavis.edu> wrote:
> On Thu, Sep 1, 2011 at 7:27 AM, Marco Lechner - FOSSGIS e.V.
> <marco.lechner at fossgis.de> wrote:
>> hi,
>>
>> I get an error when trying to add my selfcompiled rtpostgis.sql to my
>> postgis-enabled DB:
>>
>> I did a psql -d postgisDB -f rtpostgis.sql and face the following error
>>
>> ...rtpostgis.sql:8083: ERROR: >>$1<< declared as CONSTANT
>> CONTEXT: Compiling PL/pgSQL-function >>addrastercolumn<< next to line 14
>>
>> rtpostgis.sql was compiled using postgis-2.0.0SVN.tar.gz revision 7789
>> with ./configure --with-raster --with-topology
>>
>>
>> Marco
>
> Marco,
>
> Can you provide some more information?  Such as the version of
> PostgreSQL that you're running?  If you can make your rtpostgis.sql
> available, that'd be nice as well.
>
> What's strange is that nothing is declared CONSTANT in rtpostgis.sql.in.c.
>
> -bborie
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

Is your database enabled with PostGIS development version too? I mean,
did you execute postgisq.sql and spatial_ref_sys.sql in the same
database before executing rtpostgis.sql?

Strange line number too (rtpostgis.sql has 3309 lines)

-- 
Jorge Arévalo
Internet & Mobility Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g