- 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