[Mapserver-users] MapServer interface to PostGIS errors

[Vinko Vrsalovic]

Hi, just to set a record in the archives.

If you want to render data from a subquery as in:

geom from (<subquery>) as foo using unique <uniquecol> using SRID=<srid>

make sure 'from' is in lowercase.

and make sure everything you'll use in the layer (classitem, labelitem)
is actually selected in the subquery.

I'm sending this as the error messages thrown in mappostgis.c when the
above conditions are not met are not very descriptive (Postgresql reports the error '')



-- 
Vinko Vrsalovic <el[|- at -|]vinko.cl>
http://www.cprsig.cl