[mapserver-users] postgres layer not visible

[Worth Lutz]

Your PRIMARY KEY is "gid" not ID.

try:

/DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE gid 
USING SRID=5223'/


*Worth Lutz*
------------------

On 01/19/2015 04:26 AM, Maiorano Pasquale wrote:
>
> Dear Brent Fraser and everybody,
>
> The “Create Table” statement from Postgres is the following:
>
> CREATE TABLE "Fiumi_riproiettato"
>
> (
>
>   gid serial NOT NULL,
>
> "Nome" character varying(80),
>
>   "Luinghezza" integer,
>
>   the_geom geometry(LineString),
>
>   CONSTRAINT "Fiumi_riproiettato_pkey" PRIMARY KEY (gid)
>
> )
>
> WITH (
>
> OIDS=FALSE
>
> );
>
> ALTER TABLE "Fiumi_riproiettato"
>
> OWNER TO postgres;
>
> I’m looking forward to hearing You,
>
> Pasquale
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150119/003447c1/attachment.htm>