Hi, according Mapserver docs: http://mapserver.org/input/vector/postgis.html there is different syntax of using "USING UNIQUE gid USING SRID=x" string in DATA line in similar cases.
In simple case example: DATA "the_geom from the_database USING unique gid using srid=4326" In case of using a SQL subquery example: DATA "the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from geotable g join attrtable a on g.gid = a.aid) as subquery unique gid using srid=4326" When comparing these two examples, second example (SQL subquery example) is missing first "USING" keyword. Shouldn't be second example as following: DATA "the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from geotable g join attrtable a on g.gid = a.aid) as subquery USING unique gid using srid=4326" Thanks -- Ivan
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
