>
> If you want to control the values you specify for you pk, use
> a non serial primary key (one that is not associated with a sequence).
Thank you, Andrea. The table is created by PGDatastore and I haven't found a
way to alter the PK generation. Any hints on how to specify a non serial
primary key for a datastore (maybe BasicFIDMapper?)?
Torsten
On Tue, Feb 3, 2009 at 9:46 AM, Andrea Aime <[email protected]> wrote:
> thegis ha scritto:
>
>> Hi!
>>
>> I wrote my own FeatureReader to load some data and have it inserted into a
>> PostgisDatastore (with geotools 2.5.3). I like to set the FID by myself, so
>> I use
>>
>> String myId = ...;
>> builder.add( polygon );
>> builder.add( fAttr );
>> builder.add( ... );
>> SimpleFeature feature = builder.buildFeature( myId );
>>
>> That works and the feature has now my ID and all my attributes, but when
>> writing to Postgis the ID is stored anywhere. PostgisDatastore creates a
>> table that looks like:
>> Table "public.mytable"
>> Column | Type |
>> Modifiers
>> ------------------+-----------------------------+---------------------------------------------------------------------
>> mytable_fid | integer | not null default
>> nextval('mytable_mytable_fid_seq'::regclass)
>> Boundary | geometry |
>> ...
>>
>
> As far as I know, and assuming mytable_fid is pk,
> what will happen in this case is:
> - the mytable_fid column won't appear as part of the table attrbutes
> - the feature id will be built as "mytable.<mytable_fid>"
> - whatever you put as the fid will be ignored and the sequence
> be used instead (which guarantees no two features will get
> the same values, at least until the sequence runs out of values).
>
> If you want to control the values you specify for you pk, use
> a non serial primary key (one that is not associated with a sequence).
>
> Cheers
> Andrea
>
>
> --
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
>
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
