hi<br>when you says "relaunch service", you're taking about relaunch apache ? <br><br><pre>Marc André,
><i> 1- the_geom must be the name of the geometry column ?
</i>
It's not a need.
The only point is to be sure that geometry_columns table
is up to date.
So launch a populate_geometry_columns if any doubt.
><i> 2- i got a table who look like this :
</i>><i>
</i>><i> CREATE TABLE zz_tinyows_test
</i>><i> (
</i>><i> station character(254) NOT NULL,
</i>><i> the_geom geometry,
</i>><i> geom_p geometry,
</i>><i> id serial NOT NULL,
</i>><i> colonneint integer,
</i>><i> colonnetexte character(254),
</i>><i> CONSTRAINT zz_tinyows_test_pkey PRIMARY KEY (station)
</i>><i> )
</i>><i> WITH (
</i>><i> OIDS=FALSE
</i>><i> )
</i>><i> everything is fine this but if i give the primary key to "id", the
</i>><i> update is OK but i got this error in tinyows log when trying to
</i>><i> insert a point :
</i>><i>
</i>><i> [ERROR] Element '{<a href="http://****/%7Dthe_geom%27:" target="_blank">http://****/}the_geom':</a> This element is not
</i>><i> expected. Expected is one of ( {<a href="http://www.opengis.net/" target="_blank">http://www.opengis.net/</a>
</i>><i> gml}description, {<a href="http://www.opengis.net/gml%7Dname," target="_blank">http://www.opengis.net/gml}name,</a> {<a href="http://www.opengis.net/gml" target="_blank">http://www.opengis.net/gml</a>
</i>><i> }boundedBy, {<a href="http://*****/%7Dstation" target="_blank">http://*****/}station</a> ).
</i>
First question, do you relaunch service if you're running as fast-cgi
after any change in your database schema ?
(if not XSD schema cached is not up to date anymore)
If it still end on error,
thanks to send:
- ./tinyows --check
- HTTP request sended
- TinyOWS config file
><i> there is a relation with "attnum" in PG ?
</i>
Yes there is,
If you are in fast-cgi mode, perfomed at service launch
else in mode performed on each new request.
--
Olivier</pre><br>