[mapserver-users] Postgis layer not displayed

[Stefano Bonnin]

problem solved but ....

I don't know why.

In the map file there was the following line:

DATA "the_geom from restrnts"

and I changed it with 

DATA "the_geom from Restrnts"

but in postgres the table name is: restrnts and not Restrnts

With this change postgis works (????)



----- Original Message ----- 
From: "Stefano Bonnin" <shpr at libero.it>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Thursday, July 04, 2002 11:44 AM
Subject: [mapserver-users] Postgis layer not displayed


> hi,
> 
> i have some problem with a postgis layer visualization.
> 
> LAYER
>   CONNECTIONTYPE postgis
>   NAME Ristoranti
>   METADATA
>     "DESCRIPTION"   "Ristoranti"
>     "RESULT_FIELDS" "POI_NAME|Nome"
>   END
>   CONNECTION "user=postgres dbname=market_db host=localhost port=5432"
>   DATA "the_geom from restrnts"
>   TYPE POINT
>   STATUS ON
>   MAXSCALE 30000
>   CLASS
>      SYMBOL "circle"
>      SIZE 10
>      COLOR 255 0 0
>      OUTLINECOLOR 0 0 0
>          TEMPLATE blank.html
>   END
> END
> 
> i defined this layer in the map file, but it is not displayed on the map.
> The others layers are a "normal" shape layer and they are displayed
> correctly.
> 
> This one is wrong. Why?
> 
> In pgsql I have defined the restrnts table with the_geom attribute.
> have I forgotten somethig?
> 
> PS. Mapserver returns no error.
> 
> Thanks..
> Stefano



---
Outgoing mail is certified Virus Free. (FLASHH!)
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 01/07/02