Opened 14 years ago

Closed 14 years ago

#954 closed defect (fixed)

[raster] ST_AsTiff syntax error

Reported by: strk Owned by: Bborie Park
Priority: blocker Milestone: PostGIS 2.0.0
Component: raster Version: master
Keywords: Cc:

Description 

rtpostgis.sql:1132: ERROR:  "$1" is declared CONSTANT
CONTEXT:  compilation of PL/pgSQL function "st_astiff" near line 2

PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit

This is as of r7160

Change History (7)

comment:1 by strk, 14 years ago

Priority: medium → blocker

comment:2 by Bborie Park, 14 years ago

Component: postgis → postgis raster
Owner: changed from bkpark@… to Bborie Park
Status: new → assigned

comment:3 by Bborie Park, 14 years ago

Can you try r7170? The problem boiled down to modifying a function parameter in plpgsql. PostgreSQL 9.0 permits it while 8.4 does not.

comment:4 by strk, 14 years ago

With r7170: 

psql:/home/src/postgis/postgis/regress/../raster/test/regress/rtpostgis.sql:1229: ERROR:  syntax error at or near "RETURN"
LINE 3:  AS $$ RETURN st_astiff(st_band($1, $2), $3, NULL::text[], s...

comment:5 by strk, 14 years ago

if it's an SQL function you would use SELECT instead of RETURN

comment:6 by Bborie Park, 14 years ago

Oops. Somehow that got by me. That and one more fixup in r7171.

comment:7 by strk, 14 years ago

Resolution: → fixed
Status: assigned → closed

r7171 does fix the syntax error, thanks

Note: See TracTickets for help on using tickets.