[QGIS-Developer] How to update features with WFS-T & QGIS-Server 3.4?

[Piotr Bednarek]

Hi

I have a problem with WFS-T. I'm creating map using OpenLayers 5.3,
Qgis-server 3.4 and postgis 9.6-2.4. The task is to get layer with WFS and
add possibility to draw new layer records, modify(update) existing or
delete.

Getting layers, insert and delete works but there is problem with
modify(update).

I don't understand error when trying to commit update with modification. Do
you know how to fix it?
I mean "PostGIS error while changing attributes: ERROR:  prepared statement
"updatefeature" already exists" in TransactionResponse on the bottom.

Request: POST /ogc/test?request=Transaction

Body:

<?xml version="1.0" encoding="UTF-8"?>
<Transaction xmlns="http://www.opengis.net/wfs"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" service="WFS"
version="1.1.0">
   <Update xmlns:feature="feature" typeName="feature:warstwa_konsultacji">
      <Property>
         <Name>geometry</Name>
         <Value>
            <MultiPolygon xmlns="http://www.opengis.net/gml"
srsName="EPSG:3857">
               <polygonMember>
                  <Polygon srsName="EPSG:3857">
                     <exterior>
                        <LinearRing srsName="EPSG:3857">
                           <posList>2207239.1899058325 6495535.477306303
2212704.4203063278 6494579.978657217 2212589.761230811 6492898.498726965
2206589.418038072 6493089.550906483 2205977.9400751446 6493089.550906483
2208294.948366083 6494322.088930524 2207239.1899058325
6495535.477306303</posList>
                        </LinearRing>
                     </exterior>
                  </Polygon>
               </polygonMember>
            </MultiPolygon>
         </Value>
      </Property>
      <Property>
         <Name>gid</Name>
         <Value>12</Value>
      </Property>
      <Property>
         <Name>__gid</Name>
         <Value>12</Value>
      </Property>
      <Property>
         <Name>imie</Name>
      </Property>
      <Property>
         <Name>nazwisko</Name>
      </Property>
      <Property>
         <Name>adresprywa</Name>
      </Property>
      <Property>
         <Name>adres</Name>
      </Property>
      <Property>
         <Name>nrdzialki</Name>
      </Property>
      <Property>
         <Name>oznaczenie</Name>
      </Property>
      <Property>
         <Name>trescuwagi</Name>
         <Value>assd</Value>
      </Property>
      <Property>
         <Name>sesja</Name>
         <Value>1544771921921</Value>
      </Property>
      <Property>
         <Name>nrobrebu</Name>
      </Property>
      <Filter xmlns="http://www.opengis.net/ogc">
         <FeatureId fid="12" />
      </Filter>
   </Update>
</Transaction>


Response:
<TransactionResponse version="1.1.0" xmlns:ogc="http://www.opengis.net/ogc"
xmlns="http://www.opengis.net/wfs"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <TransactionSummary>
        <TotalUpdated>0</TotalUpdated>
    </TransactionSummary>
    <TransactionResults>
        <Action locator="Update:warstwa_konsultacji">
            <Message>Error committing updates: 
  Provider errors:;     PostGIS error while changing attributes: ERROR: 
prepared statement "updatefeature" already exists
    </Message>
        </Action>
    </TransactionResults>
</TransactionResponse>

code:

var WFSTSerializer = new ol.format.WFS();
var featObject = WFSTSerializer.writeTransaction(insertedFeatures,
vectorSource.getFeatures(), deletedFeatures, {
    featureType: editedLayer,
    service: 'WFS',
    version: '1.1.0',
    srsName: 'EPSG:3857',
});
var serializer = new XMLSerializer();
var featString = serializer.serializeToString(featObject);
var request = new XMLHttpRequest();
request.open('POST', location.protocol+ "//"+ location.hostname+ ":81/ogc/"
+ projectUrl + "?request=Transaction");
request.setRequestHeader('Content-Type', 'text/xml');
request.send(featString);





--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html