Opened 9 years ago

Closed 9 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 Changed 9 years ago by strk

Priority: mediumblocker

comment:2 Changed 9 years ago by Bborie Park

Component: postgispostgis raster
Owner: changed from bkpark@… to Bborie Park
Status: newassigned

comment:3 Changed 9 years ago by Bborie Park

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 Changed 9 years ago by strk

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 Changed 9 years ago by strk

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

comment:6 Changed 9 years ago by Bborie Park

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

comment:7 Changed 9 years ago by strk

Resolution: fixed
Status: assignedclosed

r7171 does fix the syntax error, thanks

Note: See TracTickets for help on using tickets.