[mapserver-users] postgres layer not visible

[Maiorano Pasquale]

Hi there 

I'm deep in the bull-shit. Help me!

I used the utility shp2img but I do not understand where the map file is
wrong.

 

Hereinafter are the three rows in the LAYER tag in the map file that
"should allow" the connection to postgres:

 

CONNECTION "dbname='gabon' host=localhost port=5432 user='postgres'
password='nicoletta' sslmode=disable"

CONNECTIONTYPE POSTGIS

DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE ID USING
UNIQUE 5223'

 

These three rows have been extracted from the map file produced by QGIS
by means of "RT mapserver export" plugin.

 

When I run the shp2img utility it replies that the ID column does not
exist, but using the pgadmin, I see the column named ID and is also the
primary key of the table "Fiumi_riproiettato"!!!

 

Where is the mistake???

 

Please help me!!.

 

Regards,

 

Pasquale

 

P.S.:       QGIS: ver 2.7 

                RT MapServer export: ver 0.4.0

                MapServer: ver. 6.0.3

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150116/e273e1ea/attachment.html>