[Mapserver-users] Query Problem with PostGIS

[Map Surfers]

I have two projects:

1) Using Shapefile
2) Using PostGIS

When performing a query (multiple layers) the query
using shapefiles all work fine. This means that all
rows for all layers are displayed properly.

When performing this same query using the PostGIS
version of a mapfile the fails. The log file reports:

[Wed.Sep.10.2003.14:46:52] MapSession_R : saveState()
done
[Wed.Sep.10.2003.14:46:52] MapSession_R : drawKeymap()
starting
[Wed.Sep.10.2003.14:46:52]   MapSession_R :
getMapObj() starting
[Wed.Sep.10.2003.14:46:52]   MapSession_R :
getMapObj() done
[Wed.Sep.10.2003.14:46:52] MapSession_R : drawKeymap()
done
[Wed.Sep.10.2003.14:46:52] MapSession_R : getMapObj()
starting
[Wed.Sep.10.2003.14:46:52] MapSession_R : getMapObj()
done
tail: /mdis/ms_tmp/colombia3.log: file truncated
[Wed.Sep.10.2003.14:46:55]   MapQuery : processQuery()
starting
[Wed.Sep.10.2003.14:46:55]   MapQuery : processQuery()
done
[Wed.Sep.10.2003.14:46:55]   QueryResults :
addResultSet() starting
[Wed.Sep.10.2003.14:46:57]     MapQuery :
processQuery() starting
[Wed.Sep.10.2003.14:46:57]     MapQuery :
processQuery() done
[Wed.Sep.10.2003.14:46:57]     QueryResults :
addResultSet() starting
[Wed.Sep.10.2003.14:46:59]       MapQuery :
processQuery() starting
[Wed.Sep.10.2003.14:46:59]       MapQuery :
processQuery() done
[Wed.Sep.10.2003.14:46:59]       QueryResults :
addResultSet() starting
[Wed.Sep.10.2003.14:47:01]         MapQuery :
processQuery() starting

The log hangs during the MapQuery.

Has this happen to anyone else?

It seems like a configuration, but have no indication
if it is php or postgres/postgis.... BTW, all features
are being displayed from both shapefiles version and
postGIS version.

TIA,

Damian

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com