<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Pena,</span></div><div><br><span></span></div><div><span>Can you post your query ?</span></div><div><br><span></span></div><div><span>You can use:</span></div><div><span><br></span></div><div><span>DATA "the_geom FROM <table>" in the traditional way<br></span></div><div><span><br></span></div><div><span>Or, if you're using a query or a view datasource, you can use:</span></div><div><span><br></span></div><div><span>DATA "the_geom FROM <query>|<view> AS <alias> USING UNIQUE <column> USING SRID=<SRC></span></div><div><br><span></span></div><div>Cheers from México<br></div><div><br><span></span></div><span></span><div><font style="font-weight:bold;color:rgb(0, 96, 191);font-family:verdana, helvetica, sans-serif;" size="2">IC Carlos Ruiz</font><br><br></div><div style="font-family: arial,
helvetica, sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Pena Kupen <kupen@wippies.fi><br><b><span style="font-weight: bold;">To:</span></b> mapserver-users@lists.osgeo.org<br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, July 14, 2011 2:59 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] Using unique<br></font><br>Sorry doubleposting! There where little "copy/paste-error". You can ignore prior...<br><br>-Pena<br><br><br>Hello all,<br><br>I'm just upgrading our system from mapserver 5.4.2 to 5.6.6.<br>In some of our layer queries, I got now error:<br>msPostGISParseData(): Query error. Error parsing PostGIS DATA variable. You must specifiy 'using unique' when supplying a subselect in the data definition.<br>When using 5.4.2, this is not
happaning and maps are working ok.<br><br>On mapserver/postgis manual (<a href="http://mapserver.org/input/vector/postgis.html" target="_blank">http://mapserver.org/input/vector/postgis.html</a>) it says:<br>The DATA parameter is used to specify the data used to draw the map. The form of DATA is “[geometry_column] from [table_name|sql_subquery] using unique [unique_key] using srid=[spatial_reference_id]”. The “using unique” and “using srid=” clauses are optional, but using them improves performance.<br><br>Is this a bug or why I cannot anymore use queries without "using unique"?<br><br>-Pena<br><br><br>-- Wippies-vallankumous on täällä! Varmista paikkasi vallankumouksen eturintamassa ja liity Wippiesiin heti!<br><a href="http://www.wippies.com/" target="_blank">http://www.wippies.com/</a><br><br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org"
href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br><br></div></div></div></body></html>