[Mapserver-users] Re: POSTGIS - subselect problem

[Stephen Woodbridge]

Good job! I think you should write a bug though because a segv is not a 
very good error message and not helpful toward pointing you toward a 
solution.

-Steve W.

Alexandros Chimarios wrote:

> Solved this problem on my own. 
> It is clearly mentioned in PostGIS manual that MapServer needs to have a 
> unique id in each row in a subselect. Therefore I created an index on unit_id 
> and I  added the unit_id column in the query  and worked.
> 
> DATA " geolocation from (SELECT geolocation, unit_id from unit_tracks) as foo 
> using unique unit_id using srid=-1  "
> 
> 
> Regards 
> 
> Alex
> 
> 
> 
> On Tuesday 27 April 2004 16:54, you wrote:
> 
>>Hello,
>>
>>I have a problem with POSTGIS and in particular with subselects. I have a
>>POSTGIS layer and everything go well when i put :
>>
>>DATA " geolocation from  unit_tracks USING UNIQUE unit_id   USING SRID = -1
>>"
>>
>>
>>... but when i put the following data(which theoritically is the same data
>>with the previous one) I get a segmentation fault :
>>
>>DATA " geolocation from (SELECT geolocation from unit_tracks) as foo using
>>unique oid using srid=-1  "
>>
>>Could anyone explain me what's happening here since subselecting is very
>>important thing.
>>
>>Thanx
>>
>>Alexandros.
> 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>