[mapserver-users] postgres layer not visible

[Rahkonen Jukka (MML)]

Hi,

You wrote earlier:

"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"!!!"

I wonder how you can see column "ID" is the table is created as to have a column ans primary key in "gid serial NOT NULL".

Do you really look at the same table with pgadmin?

-Jukka Rahkonen-



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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150119/ac49f79d/attachment.htm>