[mapserver-users] Using unique

[Carlos Ruiz]

Pena,

Can you post your query ?

You can use:

DATA "the_geom FROM <table>"in the traditional way


Or, if you're using a query or a view datasource, you can use:

DATA "the_geom FROM <query>|<view> AS <alias> USING UNIQUE <column> USING SRID=<SRC>

Cheers from México


IC Carlos Ruiz



________________________________
From: Pena Kupen <kupen at wippies.fi>
To: mapserver-users at lists.osgeo.org
Sent: Thursday, July 14, 2011 2:59 AM
Subject: [mapserver-users] Using unique

Sorry doubleposting! There where little "copy/paste-error". You can ignore prior...

-Pena


Hello all,

I'm just upgrading our system from mapserver 5.4.2 to 5.6.6.
In some of our layer queries, I got now error:
msPostGISParseData(): Query error. Error parsing PostGIS DATA variable. You must specifiy 'using unique' when supplying a subselect in the data definition.
When using 5.4.2, this is not happaning and maps are working ok.

On mapserver/postgis manual (http://mapserver.org/input/vector/postgis.html) it says:
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.

Is this a bug or why I cannot anymore use queries without "using unique"?

-Pena


-- Wippies-vallankumous on täällä! Varmista paikkasi vallankumouksen eturintamassa ja liity Wippiesiin heti!
http://www.wippies.com/

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110714/69edca23/attachment.htm>