Re: [mapserver-users] PostGIS query problem

2020-06-29 Thread Carlos Ruiz
Hola, Fernando, I don't know what's really going on but despite if this is a GDAL error or something else, I suggest you to try the following in the MAP file LAYER section: PROCESSING "CLOSE_CONNECTION=DEFER" Another question: does PostgreSQL server is running in another machine ? MSc. Carlos

Re: [mapserver-users] PostGIS query problem

2020-06-29 Thread Fernando Martins Pimenta
When I run the query in pgadmin4 query tool it works correctly. SELECT hidro.fid, 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 = UPPER('grande') When I run the same query in