[Geoserver-devel] [jira] Created: (GEOS-386) if a column is primary key in postgis, then it is completly ignored wen creating a new featureType

GeoServer GeoServer Developer
,
1

if a column is primary key in postgis, then it is completly ignored wen creating a new featureType
--------------------------------------------------------------------------------------------------

         Key: GEOS-386
         URL: http://jira.codehaus.org/browse/GEOS-386
     Project: GeoServer
        Type: Bug
  Components: PostGIS, Global, Configuration
    Versions: 1.2.3, 1.2.4, 1.2.5, 1.3.0-beta, 1.3.0-beta2, 1.3.0-beta3, 1.3.0-beta4, 1.3-rc1, 1.3-rc2
Environment: linux 2.6.11-k7
Debian
J2SDK1.5-sun
postgresql 8.03
postgis last release

Reporter: michael jenik
Assigned to: dblasby

I made this test after I realised of the existence of this specific bug.
In postgresql I did :

CREATE TABLE foo1
(
  A varchar,
  B varchar,
  CONSTRAINT foo1_pk PRIMARY KEY (B)
);

Then in geoserver had just defined a datastore for that database, so I just opened the page to create a New feature type.
Selecting pgis::foo1, I only see
"
a: string nillable:true min:0 max:1
"
in the Featuretype description form. Note that I dont see B because it is primary key.

Thanks in advance.

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

2

     [ http://jira.codehaus.org/browse/GEOS-386?page=all ]
     
dblasby reopened GEOS-386:
--------------------------

closing issues means its been fixed -- this hasnt and will continue to confuse people (it did for me). Perhaps this means more options when you make a postgis datastore (ie. what type of fidmapper you need). I'm gonna reopen this and set it for 1.4.

if a column is primary key in postgis, then it is completly ignored wen creating a new featureType
--------------------------------------------------------------------------------------------------

         Key: GEOS-386
         URL: http://jira.codehaus.org/browse/GEOS-386
     Project: GeoServer
        Type: Bug
  Components: PostGIS, Global, Configuration
    Versions: 1.2.3, 1.2.4, 1.3.0-beta2, 1.2.5, 1.3.0-beta, 1.3.0-beta3, 1.3-rc2, 1.3-rc1, 1.3.0-beta4
Environment: linux 2.6.11-k7
Debian
J2SDK1.5-sun
postgresql 8.03
postgis last release

    Reporter: michael jenik
    Assignee: dblasby
     Fix For: 1.4

Original Estimate: 7 minutes
        Remaining: 7 minutes

I made this test after I realised of the existence of this specific bug.
In postgresql I did :
CREATE TABLE foo1
(
  A varchar,
  B varchar,
  CONSTRAINT foo1_pk PRIMARY KEY (B)
);
Then in geoserver had just defined a datastore for that database, so I just opened the page to create a New feature type.
Selecting pgis::foo1, I only see
"
a: string nillable:true min:0 max:1
"
in the Featuretype description form. Note that I dont see B because it is primary key.
Thanks in advance.

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