[postgis-users] PostGis 8.1 - error with "using unique"

jerome jerome.caba at vanoise.com
Thu Dec 1 07:43:15 PST 2005


Thanks Mark,

>>$layer->set("data",$colonne_geometrique." from ".$table_choisie." as
>>foo");
>>    
>>
>
>Please see this post here:
>http://postgis.refractions.net/pipermail/postgis-users/2005-November/010087.
>html. Also I don't see any "using unique" clause in your data statement. It
>should read something like:
>
>  
>
Re-oupss, sorry, another error, in my code I have :
$layer->set("data",$colonne_geometrique." from ".$table_choisie." as foo 
using unique geometry_columns.srid using SRID=".$srid);

>$layer->set("data", $colonne_geometrique." from ".$table_choisie." using
>unique <id>");
>
>... where <id> is the name of your primary key. Since this is an issue with
>the Mapserver/PostGIS connector, you may get better assistance on the
>mapserver-users mailing list.
>
>  
>
I have tried to write "select geo_unitealpage25 from unites_alpage as 
foo using unique code_unitealpage" in SQL Manager.
the field "code_unitealpage" is my PK, like it's suggest in the forum. 
Unfortunately ! I didn't think that this error is a mapserver error, 
because, it's the same in SQL Manager or in pgAdmin.

Jerome Caba



More information about the postgis-users mailing list