[MS4W-Users] TinyOWS in MS4W does not do inserts

[Rahkonen Jukka]

Hi,

It seems obvious that the current MS4W TinyOWS package has a bug and it is impossible to do inserts with WFS-T.
We all get this kind of errors to the log

[Sat May 12 01:08:27 2012] [SQL] BEGIN;
[Sat May 12 01:08:27 2012] [SQL] SELECT nextval('public.osm_motorway_id_seq');
[Sat May 12 01:08:28 2012] [SQL] SELECT ST_GeomFromGML('<LineString xmlns="http://www.opengis.net/gml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tows="http://www.tinyows.org" srsName="EPSG:3067"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">331135.4779,6913934.7420 364545.6082,6935195.7340 331135.4779,6972655.5771 371632.6056,6981767.4309 371632.6056,6981767.4309 370620.1774,6982779.8590 371632.6056,6981767.4309 371632.6056,6981767.4309 394918.4540,6990879.2846</coordinates></LineString>')
[Sat May 12 01:08:28 2012] [SQL] SELECT ST_IsValid('0102000020FB0B0000090000001B9E5EE9FD35144191ED7CAFE35F5A4116FBCB6E0640164123DBF9EEA6745A411B9E5EE9FD351441D734EFE43B995A410A68226CC2AE164198DD93DB21A25A410A68226CC2AE164198DD93DB21A25A417958A8B5F09E164123DBF9F61EA35A410A68226CC2AE164198DD93DB21A25A410A68226CC2AE164198DD93DB21A25A414260E5D0991A1841EBE236D207AB5A41')

The last line in the TinyOWS log means that PostGIS is checking the validity of the geometry to be inserted. It is valid but after that the tinyows process dies and the Windows dr. Watson starts to generate a report.

The TinyOWS version in the package is 1.0.0rc3. Release version 1.0 has been published after that. Perhaps you MS4W folks could have a quick try by creating a new package from the 1.0 release and see if the WFS-T insert bug would be cured at the same?

-Jukka Rahkonen.