[mapserver-users] RE: nquery against postgis layer

[Fawcett, David]

To answer my own question...

It turns out that in the query for my data statement, I was using a
character column that didn't have a unique constraint on it.  When I
changed the statement to reference the gid column (e.g.  'using unique
gid'), it worked.  

David.

To paraphrase Dr. Dre, 'nothing but a gid thang...'

-----Original Message-----
From: Fawcett, David 
Sent: Monday, March 23, 2009 3:11 PM
To: mapserver-users at lists.osgeo.org
Subject: nquery against postgis layer


I am banging my head against an nquery request to a postgis based layer.
This is on MS 5.2.1 on OSX using William's binaries.  

I can draw the layer in mode=map, but when I use mode=nquery, the query
doesn't return any results and my templates aren't populated properly.
I am not passing a point or extent in the query request URL.  

I have a similar nquery request against a shapefile based layer and it
works fine.  

Can anyone think of anything PostGIS specific that might cause this?  I
did a quick search of bug tickets in Trac and the listserv and didn't
see anything.  

David.