[postgis-users] PostGis/MapServer ... Query-Problem

Fri Sep 12 05:07:39 PDT 2003

hi folks,

we need your help.
we wnt to query a postgis-layer with mapserver, but we get this error.
we have made the oid an the sql-statement is: "the_geom from punkte_tabelle
using unique oid using SRID=-1"

The Error:
-------------------------

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

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

Table punkte_tabelle with index punkte_tabelle_oid_idx (oid).

The Layer-Definition:
------------------------

LAYER
  CONNECTIONTYPE postgis
  NAME pers_punkte
  CONNECTION "user=postgres password=ppp dbname=test_db"
  DATA 'the_geom from punkte_tabelle using unique oid using SRID=-1'
  TYPE POINT
  STATUS ON
  HEADER
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt_hea
der.html"
  FOOTER "halgis_alle_footer.html"
  CLASS
    NAME 'Punkte'
    TEMPLATE
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt.htm
l"
    OUTLINECOLOR 0 0 220
    COLOR 0 0 220
    SYMBOL 'circle'
    size 12
  END
END

Thanks very much!

::: mfg. Mike Elstermann [mikeE.], Teamleiter GIS/RIS, e-Solutions
::: IT-Consult Halle GmbH, Bornknechtstraße 5, 06108 Halle (Saale)
::: Sitz: Große Nikolaistraße 8
::: Tel.: +49 345 221 4237, Fax: +49 345 221 4236, mobil: +49 160 71 545 02
::: mike.elstermann at itc-halle.de ::: http://www.itc-halle.de
::: GeoDaten Online? -> http://www.itcgis.de