PostGIS error on 4.8b2

Ken Lord kenlord at GMAIL.COM
Fri Dec 9 21:33:42 EST 2005


I haven't seen a response to this variation of the postgis / 4.8b2
issue yet, as posted by someone else.

Has anyone figured out how to use PostgreSQL 8.0.3 / PostGIS 1.0.4
with MapServer 4.8b2?

I have an OID column, I'm not using PostgreSQL 8.1.  But my DATA query
is rejected with an error near USING  ...

If I use another unique column present in the table, it produces the
same error. This query did work with mapserver 4.6.

Here's my DATA string:

DATA "wkb_geometry FROM (SELECT * FROM my_funky_table) AS foo USING
UNIQUE ogc_fid USING SRID=26910"

And here's the error:

msDrawMap(): Image handling error. Failed to draw layer named 'Funky_Table'.
prepare_database(): Query error. Error executing POSTGIS DECLARE (the
actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
text::text,asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_fid::text
from (SELECT * FROM my_funky_table) AS foo USING UNIQUE ogc_fid WHERE
wkb_geometry && setSRID('BOX3D(499573.999999999
5463794,499664.000000001 5463866)'::BOX3D, 26910 )'

Postgresql reports the error as 'ERROR: syntax error at or near
"USING" at character 169 '

Thanks,
Ken Lord
Vancouver BC



More information about the mapserver-users mailing list