[TinyOWS-users] OSM_line table and failing DescribeFeatureType

[Rahkonen Jukka]

Hi,

One more piece of information:
Osm2pgsql creates tables osm_point, osm_line and osm_polygon. They are all without primary keys and that will make TinyOWS to fail with DescribeFeatureType. Adding primary keys into those tables corrects DFT but osm_id field which looks like a good candidate can contain dublicate values. Therefore it may be best to create primary keys as
ALTER TABLE osm_line add myid serial;
ALTER TABLE osm_line ADD PRIMARY KEY (myid);

-Jukka Rahkonen-

> Rahkonen Jukka wrote
> 
> Hi,
> 
> Adding primary key into the table made DescribeFeatureType to 
> work. It might be worth a note in the user documents?
> 
> -Jukka Rahkonen-
> 
> 
> -----Alkuperäinen viesti-----
> Lähettäjä: tinyows-users-bounces at lists.maptools.org puolesta: 
> Olivier Courtin
> Lähetetty: ke 15.9.2010 16:23
> Vastaanottaja: TinyOWS users discuss list
> Aihe: Re: [TinyOWS-users] OSM_line table and failing 
> DescribeFeatureType
>  
> 
> On Sep 15, 2010, at 2:25 PM, Rahkonen Jukka wrote:
> 
> 
> > But sorry, I am total beginner here and I do not know what 
> you mean  
> > with .sql file.
> 
> You're welcome :)
> I mean a way to load data into PostGIS and so to (try to) reproduce  
> your issue.
> 
> So the output of osm2pgsql is valuable
> You could also produce a shapefile of your table file with pgsql2shp
> 
> --
> Olivier
> 
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users
> 
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users
>