[Chameleon] Query postgis layer

[Eric Bridger]

On Fri, 2004-11-12 at 14:33, Mark M wrote:
> Hi,
> 
> I can plot and query information from shp files. When I add a layer from postgis as in , 
> 
>     CONNECTION "user=postgres dbname=water host='127.0.0.1'"
>     CONNECTIONTYPE POSTGIS
>     DATA "the_geom from (SELECT  local_coordinates AS the_geom, locale.oid AS oid, name
>      from  locale)
>      USING UNIQUE oid USING SRID=-1"
>     TEMPLATE "ttt_query.html"
> 
> I can see the points but when I try to query them I get 'The layers did not return any results'. I can still query the shp files without a probelm. Any idea what's up?

Mark,

Try adding:
TOLERANCE 5
TOLERANCEUNITS pixels

to your POSTGIS layer.

Eric