[mapserver-users] PostGIS query problem

[Jeff McKenna]

Hi Fernando,

I would try using the shp2img utility at the commandline, and set CONFIG 
"CPL_DEBUG" "ON" in your mapfile (see 
https://mapserver.org/optimization/debugging.html#step-3-turn-on-cpl-debug-optional) 
and then execute:

   shp2img -m mymap.map -o ttt.png -all_debug 5

The full query should be listed there in the response, which you can 
then paste into the psql commandline, and manually execute the same 
query to your database.

PS. hello to my friends in Brasil!

-jeff



-- 
Jeff McKenna
MapServer Consulting and Training Services
co-founder of FOSS4G
http://gatewaygeo.com/


On 2020-06-25 5:16 p.m., Fernando Martins Pimenta wrote:
> Hi,
> 
> I am using the query below to return a hydrograph of a region (using 
> POSTGIS). This query works perfectly when I use it in pgadmin. With the 
> mapserver, the connection with the client is lost. It records a query 
> that shows no errors in SQL, just shows that the connection has lost. 
> Why is that?
> 
> DATA "geom FROM (
>           SELECT
>              hidro.fid, hidro.name <http://hidro.name>, 
> ST_Intersection(gcc.geom, hidro.geom) AS geom
>            FROM
>              vector.hidrography AS hidro,
>              vector.gcc AS gcc
>            WHERE ST_Intersects(gcc.geom, hidro.geom) AND gcc.name 
> <http://gcc.name> = 'GRANDE'
> ) as subquery USING UNIQUE fid USING SRID=4326"
> 
> Thanks in advance
> 
> *Fernando Martins Pimenta <http://lattes.cnpq.br/0646984654461300>*
> Graduando em Engenharia de Agrimensura e Cartográfica - UFV
> Bacharel em Engenharia de Biossistemas - UFSJ
> 
> www.biosfera.dea.ufv.br <http://www.biosfera.dea.ufv.br>
> 
> 
>