<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<style>BODY{font:10pt Tahoma,Verdana,sans-serif} .MsoNormal{line-height:120%;margin:0}</style></head><body>
Hi, Olivier<br><br>Here is most part of my tinyows.xml (online_resource is ok, also I set check_schema to "0"):<br><br><tinyows online_resource="http://localhost/mapserver/tinyows"<br> schema_dir="/usr/local/share/tinyows/schema/"<br> log="/tmp/tinyows.log"<br> check_schema="0"<br> log_level="15"><br><pg host="localhost" user="timur" dbname="<some_db>" port="5432"/><br><metadata name="TinyOWS Server"<br> title="TinyOWS Server - WFS-T Frida Service" /><br><contact name="TinyOWS Server"<br> site="http://www.tinyows.org/"<br> email="tinyows-users@lists.maptools.org" /><br><layer retrievable="1"<br> writable="1"<br> ns_prefix="tows"<br> ns_uri="http://www.tinyows.org/"<br> name="cities"<br> title="Russian cities" /><br></tinyows><br><br>After disabling schema_check I get the following record in logfile:<br><br>[Thu Nov 8 12:42:15 2012] [EVENT] == Filling Storage ==<br>[Thu Nov 8 12:42:15 2012] [EVENT] == FCGI START ==<br>[Thu Nov 8 12:42:15 2012] [QUERY] <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd http://www.tinyows.org http://localhost/mapserver/tinyows?service=wfs&amp;request=DescribeFeatureType&amp;version=1.1.0&amp;typename=tows:cities" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Insert><feature:cities xmlns:feature="http://www.tinyows.org"><feature:geom><gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:4326"><gml:pos>38.10537109375 55.365478515625</gml:pos></gml:Point></feature:geom><feature:pop_hk>99</feature:pop_hk><feature:city_name>Новый город</feature:city_name><feature:type_id>1</feature:type_id></feature:cities></wfs:Insert></wfs:Transaction><br>[Thu Nov 8 12:42:15 2012] [SQL] BEGIN;<br>[Thu Nov 8 12:42:15 2012] [SQL] SELECT nextval('public.cities_obj_id_seq');<br>[Thu Nov 8 12:42:15 2012] [SQL] INSERT INTO "public"."cities" ("obj_id") VALUES ('693') <br>[Thu Nov 8 12:42:15 2012] [SQL] COMMIT;<br>[Thu Nov 8 12:42:15 2012] [EVENT] == FCGI SHUTDOWN ==<br>[Thu Nov 8 12:42:15 2012] [EVENT] == TINYOWS SHUTDOWN ==<br><br>And that is not exactly the right thing because none of the 'cities' table's fields are filled (values for them are provided in query above).<br><br>I'm putting 'cities' table definition here for the whole picture:<br>-----------+------------------------+-------------------------------------------<br> obj_id | integer | NOT NULL DEFAULT nextval('cities_obj_id_seq'::regclass)<br> pop_hk | integer | <br> city_name | character varying(100) | <br> geom | geometry(Point,4326) | <br> "cities_pkey" PRIMARY KEY, btree (obj_id)<br> "cities_type_id_fkey" FOREIGN KEY (type_id) REFERENCES types(type_id)<br><br>Best regards,<br>Timur Sufiev<br><blockquote style="padding-left: 5px; margin-left: 5px; border-left: #0000ff 2px solid; margin-right: 0px"><hr><b>From:</b> Olivier Courtin [mailto:olivier.courtin@gmail.com]<br><b>To:</b> mapserver-users@lists.osgeo.org<br><b>Sent:</b> Wed, 07 Nov 2012 21:24:24 +0300<br><b>Subject:</b> Re: [mapserver-users] [TinyOWS] Inserting feature and XML schema validation<br><br>On Wed, Nov 7, 2012 at 5:13 PM, Тимур Галиаскарович Суфиев <span><<a href="mailto:t.sufiev@acti.ru">t.sufiev@acti.ru</a>></span> wrote:<br><div class="gmail_quote"><div><br>Hi Timur,<br> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>This isn't the first question here about inserting features in TinyOWS, but I haven't found solution to my problem in archives.<br>
<br>and this xsd should make tinyows use element '{<a href="http://www.tinyows.org">http://www.tinyows.org</a>}cities' like '{<a href="http://www.opengis.net/gml%7D_Feature">http://www.opengis.net/gml}_Feature</a>'<br>
<br>Where am I wrong and what should be changed in my setup?<br></div></blockquote><div><br>Thanks for your detailled report,<br>first naive question, what about the tinyows.xml config file,<br> and online_resource property ?<br>
<br>Next question, what happen, if you bypass schema validation, <br>with: check_schema = "0" (in tinyows element)<br><br>--<br>Olivier<br>
</div></div>
</blockquote><style>
</style>
</body></html>