Hi Jukka, you are right about the problems related to the reserved Postgres(i have doubts here, maybe is a GeoServer+Postgres problem?) keywords like "name" or "description" used as fields, i know this fact. But this is not the case. When i use the "DescribeFeatureType" request with version=1.0.0, the returned xml is Ok, the problems appears when i use version=1.1.0 (it refuses to describe the "name" or"description"-like fields). Even changing the field name hasn't solved the update problem..
Best, Dorin On 02.08.2011 14:07, Rahkonen Jukka wrote: > Hi, > > Try to rename the "name" attribute to something else, like name_debug. > PostgreSQL reserved keywords may cause odd problems. > > -Jukka Rahkonen- > ________________________________________ > Lähettäjä: Dorin Tcaci [[email protected]] > Lähetetty: 2. elokuuta 2011 12:12 > Vastaanottaja: [email protected] > Aihe: Re: [Geoserver-users] WFS-T update doesn't work > > Thank you Andrea for the answer, > read my answers bellow: > > - are you trying to update a column that maybe does not exist in the table? > No, also in this case the error exception says clearly that the field > doesn't exist. > > - did the table structure change since you started GeoServer? > No. > It would be useful to see: > - the table structure (the create table statement, or a table > description of some kind). > ------------------------------------------------ > CREATE TABLE "public"."HOTSPOT" ( > "id" SERIAL, > "gid" VARCHAR(50) NOT NULL, > "name" VARCHAR(80), > "the_geom" "public"."geometry" NOT NULL, > "information" VARCHAR(100), > CONSTRAINT "HOTSPOT_gid_key" UNIQUE("gid"), > CONSTRAINT "HOTSPOT_pkey" PRIMARY KEY("id"), > CONSTRAINT "enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2), > CONSTRAINT "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = > 'POINT'::text), > CONSTRAINT "enforce_srid_the_geom" CHECK (st_srid(the_geom) = (-1)) > ) WITHOUT OIDS; > > ---------------------------------------------- > - the result of calling DescribeFeatureType on that layer > > <xsd:schema elementFormDefault="qualified" > targetNamespace="http://www.pp.fr";> > <xsd:import namespace="http://www.opengis.net/gml"; > schemaLocation="http://localhost:80/geoserver/schemas/gml/2.1.2/feature.xsd"/> > <xsd:complexType name="HOTSPOTType"> > <xsd:complexContent> > <xsd:extension base="gml:AbstractFeatureType"> > <xsd:sequence> > <xsd:element maxOccurs="1" minOccurs="1" name="id" nillable="false" > type="xsd:int"/> > <xsd:element maxOccurs="1" minOccurs="1" name="gid" nillable="false" > type="xsd:string"/> > <xsd:element maxOccurs="1" minOccurs="0" name="name" nillable="true" > type="xsd:string"/> > <xsd:element maxOccurs="1" minOccurs="1" name="the_geom" > nillable="false" type="gml:GeometryPropertyType"/> > <xsd:element maxOccurs="1" minOccurs="0" name="information" > nillable="true" type="xsd:string"/> > </xsd:sequence> > </xsd:extension> > </xsd:complexContent> > </xsd:complexType> > <xsd:element name="HOTSPOT" substitutionGroup="gml:_Feature" > type="PP:HOTSPOTType"/> > </xsd:schema> > > - the WFS-T request > ---------------------------------------------------------------------------- > > var featureType = 'HOTSPOT'; > var featurePrefix = 'PP'; > var srsName = 'EPSG:2154'; > var url = "http://localhost:80/geoserver/wfs"; ; > > var layer = new OpenLayers.Layer.Vector("hotspot", { > projection: new > OpenLayers.Projection(srsName), > protocol: new > OpenLayers.Protocol.WFS({ > version: "1.1.0", > url: url, > featureType: featureType, > featureNS: 'http://www.pp.fr', > srsName: srsName, > geometryName: "the_geom", > schema: url + > '/DescribeFeatureType?version=1.0.0&TypeName=' +featurePrefix +':'+ > featureType > }), > minScale: 10000, > styleMap: style_Map, > }); > > and the issued POST: > -------------------------------------------------------------------------------------- > <wfs:Transactionxmlns: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.pp.fr > http://localhost:80/geoserver/wfs/DescribeFeatureType?version=1.0.0&TypeName=PP:HOTSPOT"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > <wfs:UpdatetypeName="feature:HOTSPOT"xmlns:feature="http://www.pp.fr";> > <wfs:Property> > <wfs:Name>the_geom</wfs:Name> > <wfs:Value> > <gml:Pointxmlns:gml="http://www.opengis.net/gml"srsName="EPSG:2154";> > <gml:pos>654215.0496587127 6861900.8752494445</gml:pos> > </gml:Point> > </wfs:Value> > </wfs:Property> > <wfs:Property> > <wfs:Name>id</wfs:Name> > <wfs:Value>9</wfs:Value> > </wfs:Property> > <wfs:Property> > <wfs:Name>gid</wfs:Name> > <wfs:Value>4</wfs:Value> > </wfs:Property> > <wfs:Property> > <wfs:Name>information</wfs:Name> > <wfs:Value>hotspot info</wfs:Value> > </wfs:Property> > <wfs:Property> > <wfs:Name>name</wfs:Name> > <wfs:Value>hotspot</wfs:Value> > </wfs:Property> > <ogc:Filterxmlns:ogc="http://www.opengis.net/ogc";> > <ogc:FeatureIdfid="HOTSPOT.9"></ogc:FeatureId> > </ogc:Filter> > </wfs:Update> > </wfs:Transaction> > ------------------------------------------------------------------------- > > Regards, > Dorin > > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos& much more. Register early& save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Cordialement, Dorin TCACI Développeur IM "Pentalog CHI" SRL 10, rue Calea Iesilor, Chisinau, Moldova www.pentalog.md ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
