<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><div><br></div><div>What client are you using?<br></div><div>How long does the query take to complete?<br></div><div>It is likely the client stops waiting for a response.<br></div><div><br></div><div>Seth<br></div><div><br></div><div id="sig62266145"><div>--<br></div><div>web:http://geographika.co.uk<br></div><div>twitter: @geographika<br></div></div><div><br></div><div><br></div><div>On Thu, Jun 25, 2020, at 10:16 PM, Fernando Martins Pimenta wrote:<br></div><blockquote type="cite" id="qt" style=""><div dir="ltr"><div>Hi,<br></div><div><br></div><div><span style="white-space:pre-wrap;background-color:rgb(248, 249, 250);"><span class="font" style="font-family:arial, sans-serif;">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?</span></span><br></div><div><span style="white-space:pre-wrap;background-color:rgb(248, 249, 250);"><span class="font" style="font-family:arial, sans-serif;"></span></span><br></div><div><div>DATA "geom FROM (<br></div><div> SELECT<br></div><div> hidro.fid, <a href="http://hidro.name">hidro.name</a>, ST_Intersection(gcc.geom, hidro.geom) AS geom<br></div><div> FROM<br></div><div> vector.hidrography AS hidro, <br></div><div> vector.gcc AS gcc<br></div><div> WHERE ST_Intersects(gcc.geom, hidro.geom) AND <a href="http://gcc.name">gcc.name</a> = 'GRANDE' <br></div><div> ) as subquery USING UNIQUE fid USING SRID=4326"<br></div></div><div><br></div><div><div>Thanks in advance<br></div><div><div dir="ltr" class="qt-gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><span style="color:rgb(0, 0, 0);"><span style="background-color:rgb(255, 255, 255);"><span class="size" style="font-size:13px;"></span></span></span><br></div><div><div><span style="color:rgb(0, 0, 0);"><span style="background-color:rgb(255, 255, 255);"><span class="size" style="font-size:13px;"><b><a href="http://lattes.cnpq.br/0646984654461300" target="_blank">Fernando Martins Pimenta</a></b></span></span></span><br></div><div>Graduando em Engenharia de Agrimensura e Cartográfica - UFV<br></div><div>Bacharel em Engenharia de Biossistemas - UFSJ<br></div><div><br></div><div><a href="http://www.biosfera.dea.ufv.br" target="_blank">www.biosfera.dea.ufv.br</a><br></div><div><img src="https://docs.google.com/uc?id=0BwEKA5E4J-qwcmZVMDJDMm9FUEE&export=download" width="96" height="48"><br></div></div></div></div></div></div></div></div></div></div></div></div><div>_______________________________________________<br></div><div>mapserver-users mailing list<br></div><div><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div></blockquote><div><br></div></body></html>