Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-29 Thread Ragi Burhum
> > From: Peter J Halls > Subject: Re: [gdal-dev] Coding for appending to a database in OGR > To: Frank Warmerdam > Cc: gdal-dev@lists.osgeo.org > Message-ID: <4ccad1df.60...@york.ac.uk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Thanks, Fr

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-29 Thread Peter J Halls
Thanks, Frank ... Frank Warmerdam wrote: Peter J Halls wrote: Frank and team, having reviewed the code again and the comments made by others, for which thanks, it seems to me that there is a possible solution that might resolve all the concerns. I've asked my DBA for performance expecta

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-29 Thread Frank Warmerdam
Peter J Halls wrote: Frank and team, having reviewed the code again and the comments made by others, for which thanks, it seems to me that there is a possible solution that might resolve all the concerns. I've asked my DBA for performance expectation comments, but have not yet heard back

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-29 Thread Peter J Halls
Frank and team, having reviewed the code again and the comments made by others, for which thanks, it seems to me that there is a possible solution that might resolve all the concerns. I've asked my DBA for performance expectation comments, but have not yet heard back from him. Instead

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Even Rouault
Selon Peter J Halls : Not using it, it's hard for me to comment on OCI peculiarities. I've looked quickly at the code of ogroctitablelayer.cpp and it seems to be consistant with the behaviour you describe : if you set a FID before using CreateFeature() it will use it, otherwise it will use a seria

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Anders Moe
An interesting discussion, but shouldn't the layer table have been cread with a UNIQUE contraint in the ID column in the first place ? Anders On Thu, Oct 28, 2010 at 5:02 PM, Frank Warmerdam wrote: > Peter J Halls wrote: > >> Even and team, >> >> following the hint from Even's post below, I ha

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Frank Warmerdam
Peter J Halls wrote: Even and team, following the hint from Even's post below, I have been experimenting with OGR_F_SetFID to get the FID for appends to increment beyond the existing value, rather than always to start at 1. I'm testing against the OCI driver and am not (yet) using 1.8.

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Peter J Halls
Even and team, following the hint from Even's post below, I have been experimenting with OGR_F_SetFID to get the FID for appends to increment beyond the existing value, rather than always to start at 1. I'm testing against the OCI driver and am not (yet) using 1.8. I've found that the

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Peter J Halls
Even, thank you for your response. I had missed feat.SetFID, mentioned in the PG ticket, so will have a go with that. For the record, I'm currently working against the OCI driver but wish to be reasonably independent of the underlying database implementation - hence use of OGR. Thank

Re: [gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Even Rouault
Hi Peter, Do you mean that just after issuing a CreateFeature(), the feature ID isn't set to the correct value (the one that you'll find after dataset reopening) ? You have to be more specific about which OGR driver you are talking about because the mechanisms for setting/retrieving FID is driver

[gdal-dev] Coding for appending to a database in OGR

2010-10-28 Thread Peter J Halls
Dear Team, I've reviewed the change log for release 8 so far and do not think that this question is version specific. I'm coding to support an incremental process for loading a large spatial database from a set of distribution objects. I have noted that my present approach results i