- Geoserver version: 2.14.1 and 2.18.0.
   - My store is Postgis.
   - Those are my tables, there is no relation on database level

create table example_table(
    id serial primary key,
    name varchar(100),
    geom geometry(Point, 4326)
);create table name(
    id serial primary key,
    key varchar(100)
);

I executed this sql query, then I just published example_table. here
is my insert transaction.


<wfs:Transaction service="WFS" version="1.1.0"
  xmlns:wfs="http://www.opengis.net/wfs";
  xmlns:topp="http://www.openplans.org/topp";
  xmlns:gml="http://www.opengis.net/gml";
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
  xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd
http://www.openplans.org/topp
http://localhost:8080/geoserver/wfs/DescribeFeatureType?typename=feyzullah_test:example_table";>
  <wfs:Insert>
    <example_table>
      <name>isim</name>
      <geom>
        <Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326";>
              <coordinates decimal="." cs="," ts=" ">29,41</coordinates>
        </Point>
      </geom>
    </example_table>
  </wfs:Insert></wfs:Transaction>


   - Then It is inserted successfully.
   - I published the other layer called name
   - Then I executed the same transaction XML again and I got an error. The
   error says: value too long for type character varying(100). but is not
   that long. Here is the what GeoServer generated for insert query

INSERT INTO "public"."example_table" ( "name","geom" )VALUES
('SimpleFeatureImpl:name=[SimpleFeatureImpl.Attribute: key<key
id=fid-55948f24_176ad551553_-7fb5>=null]',
ST_GeomFromText('POINT (29 41)', 4326)
)


   - When I unpublish the layer called name, this error is not firing. We
   have had an app in production for over 2 years, this was not happening
   until we realized this error. This error is not happening in the update
   transaction.
   - So, if we have a table like foo and another layer has a column called
   foo we cannot execute insert transaction successfully.
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to