WFS-T issues when table is not in the default schema (primary key not found)
----------------------------------------------------------------------------
Key: GEOS-1086
URL: http://jira.codehaus.org/browse/GEOS-1086
Project: GeoServer
Issue Type: Bug
Components: PostGIS
Affects Versions: 1.5.0
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 1.5.1
From a user report:
Hi, I am new to geoserve. We are developing an application using postGIS, geoserver and mapbuilder. I am trying to insert a new feature (polygon), I don't get any error message, but feature is not added. Can anyone figure out why feature is not added? The message shown on browser is Transaction Status: wfs:SUCCESS New Feature Id: landparcels.null
...
Yes there is primary key.
Table structre is
"
CREATE TABLE "LRMIS_SCH".landparcels
(
"Id" integer NOT NULL DEFAULT
nextval('"LRMIS_SCH".landparcels_gid_seq'::regclass),
"pStatus" character varying(30),
"Possession" character varying(1),
"khasraNo" smallint,
the_geom geometry,
CONSTRAINT landparcels_pkey PRIMARY KEY ("Id"),
CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 32643)
)
WITHOUT OIDS;"
...
I was able to get value by "select
currval(pg_get_serial_sequence("LRMIS_SCH.landparcels", "Id"));" in SQL
editor of pgis, however after inserting a record(session was created).
But the problem remained.
Then I transferred relation (converted shape file) to public schema from
"LRMIS_SCH", it worked.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira