[Mapserver-users] Postgis "explain verbose"-Error

Christina Biakowski CCGIS christina.biakowski at ccgis.de
Mon May 12 09:44:58 EDT 2003


Hello,
we are running Mapserver 3.6.5 on FreeBSD with Postgresql 7.3.2 and Postgis
7.4.
Querying a Postgis-Layer (by clicking in the map) I get the following
error-message:

"msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL
statement (in FETCH ALL): EXPLAIN VERBOSE SELECT * FROM staedte - Error with
POSTGIS data variable. You specified ''.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column name>
using SRID=<srid#>'

Make sure you put in the 'using unique <column name>' and 'using SRID=#'
clauses in.
..."

I searched the mailing-archive and found that it is "a problem with
postgresql 7.3's handling of "EXPLAIN VERBOSE" and that there is a fix for
the problem. Could anybody tell me where to get the fix or whether there
might also be another reason for the produced error?

Thanks in advance!

Regards,

Christina




More information about the mapserver-users mailing list