[Geoserver-devel] [jira] Created: (GEOS-1885) Failure in PostGIS store when dealing with serial attribute

Failure in PostGIS store when dealing with serial attribute
-----------------------------------------------------------

                 Key: GEOS-1885
                 URL: http://jira.codehaus.org/browse/GEOS-1885
             Project: GeoServer
          Issue Type: Bug
          Components: WFS
    Affects Versions: 1.6.3
            Reporter: Jean-Pierre Fiset
            Assignee: Andrea Aime

When adding a layer in geoserver against a database table that contains a serial attribute, it is impossible to submit a WFS request without specifying the serial attribute. An error is returned. The expected behaviour would be for the database to assign the next available value for the serial attribute.

What happens is that geoserver attempts to set the attribute to null. Given that a serial is mapped to a non null integer, the database can not accept the request.

In fact, the expected behaviour should be that geoserver submit a SQL request to PostGIS without specifying the missing attribute. This way, the database would perform the request correctly.

This error was found on geoserver/trunk/geoserver@anonymised.com

--
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