Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting
query errors.
I've posted a Gist at [1] to help in reporting. Note that this functionality
used to work in 6.4.x.
From the migration guides it doesn't look like much has changed w.r.t. PostGIS
syntax in
the mapfile. Any idea what could be going on here? It looks like the query
that is constructed
by mappostgis.c is something like:
select
"stn_nam","avg_wnd_dir_10m_mt58_60","avg_wnd_spd_10m_mt58_60_symbol","air_temp","stn_pres","mslp","dwpt_temp","rel_hum","observation_qa_summary","observation_qa_problem_summary",encode(ST_AsBinary(ST_Force2D("the_geom"),'NDR'),'hex')
as geom,"data_payload_id" from (select * from data_mart_ca_live order by
instance_datetime desc) as subquery where the_geom &&
ST_GeomFromText('POLYGON((-127.881959628204 63.7547758989546,-127.881959628204
70.5833900726923,-103.751686743445 70.5833900726923,-103.751686743445
63.7547758989546,-127.881959628204 63.7547758989546))',4326) and ()
Note the trailing "()". When I remove the "()" and try direct in psql, the
query works.
Any idea what could be going on here?
Thanks
..Tom
[1] https://gist.github.com/tomkralidis/26cb7214e282c144ba61598116d458e7
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
