Miles Jordan wrote: > I have this problem where I am pulling a feature type out of oracle > and putting it into postgis. The primary key, "voyage_id" in the > oracle table is being stripped from the feature type and replaced with > a generic "fid" column. > > The voyage_id is a foreign key and can be referenced via web > applications too, so it needs to be there, and be the same. The fid > column seems to be created using a new sequence, so the data in the > voyage_id column is dropped altogether.
Found it at http://jira.codehaus.org/browse/GEOS-386, it just took a while. So you can use datastore.setExposePrimaryKeyColumns(true) and it works. I'm still confused as to why a new sequence was created for the fid in the first place, considering that Oracle is providing a primary key. What about within Geoserver though; could there be some option to have it show primary keys as normal feature attributes? Regards, Miles ___________________________________________________________________________ Australian Antarctic Division - Commonwealth of Australia IMPORTANT: This transmission is intended for the addressee only. If you are not the intended recipient, you are notified that use or dissemination of this communication is strictly prohibited by Commonwealth law. If you have received this transmission in error, please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and DELETE the message. Visit our web site at http://www.antarctica.gov.au/ ___________________________________________________________________________ ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
