[Mapserver-users] error and mapserver+postgis demo

[Paolo PP. Pulli]

Hi,

I've similar trouble report here
http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0303/msg00767.html

My environment is:
W2000
Apache HTTP Server Version 1.3
MapServer version 3.6.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP SUPPORTS=PROJ SUPPORTS=TTF SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

PostgresSQL(7.3.2)-PostGIS(0.7.4) is on linux box(Debian) (another pc)

Map file:
...
LAYER
  NAME punti
  CONNECTIONTYPE postgis
  CONNECTION "user=quadword dbname=gistest host=192.1.xxx.xxx"
  DATA "the_geom from punti"
  TYPE POINT
  STATUS ON
  CLASS
     NAME "Test point"
     SYMBOL 7 # I declare before SYMBOLSET
     SIZE 6
     TEMPLATE "punti.html"
     TEMPLATE "query_punti.html"
     COLOR 100 150 100
    OUTLINECOLOR 0 0 0
  END
  TOLERANCE 3
  DUMP TRUE
END # punti
...

Where punti is my postGIS table create with:
create table punti (gid int4 , ID int4);
select AddGeometryColumn('GisTest','punti','the_geom','-1','POINT',2);
insert into punti values ('0','4784',GeometryFromText('POINT (2791441.1 4473839.2)',-1) );
...

When I do 
<http://localhost/cgi-bin/mapserv>?layer=punti&mode=query&......

Browser give me:
Content-type: text/html msPOSTGISLayerGetItems(): Query error. Error executing POSTGIS SQL statement: EXPLAIN VERBOSE SELECT * FROM punti

If mode=browse all work OK, if I use local shape file, too

What is wrong and how to fix it?

Any help would be appreciated!