Re: [Geoserver-users] problem with wfs-t and postgis

[pablo l. <pla...@gm...>]

I solved this issue by changing the geometrytype in postgis from POLYGON to
MULTIPOLYGON. i'm still not sure why this worked since the error thrown by
geoserver had nothing to do (as far as I can see) with enforcing geometry
type.
Thanks anyway

On Fri, Jul 16, 2010 at 11:56 AM, pablo lopez <pla...@gm...> wrote:

> Hi list, I have a strange problem performing a wfs-t insert against a
> postgis table. My post request is as follows:
>
> http://pastebin.com/8pKVvuF4
>
> While the response from geoserver is :
>
> http://pastebin.com/3kXTGPE1
>
> The postgis table is created as follows:
>
>
> CREATE TABLE plr_u_q1
> (
>   gid serial NOT NULL,
>   the_geom geometry,
>   CONSTRAINT plr_u_q1_pkey PRIMARY KEY (gid),
>   CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
>   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
> 'POLYGON'::text OR the_geom IS NULL),
>   CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)
> )
> WITH (
>   OIDS=FALSE
> );
>
> I've been able to do several inserts into postgis tables using the same
> configuration, the only difference is that this postgis table is empty (no
> records in it).
>
> Any help is appreciated
> Thanks in advance
> Pablo
>