Carto: Double upload results in sequence errors
|Reported by:||pramsey||Owned by:||warmerdam|
Running this upload twice
ogr2ogr \ --config DEBUG ON \ --config CARTO_API_KEY xxxxxxxx \ -t_srs EPSG:4326 \ -f Carto \ -nln pts_tmp \ "Carto:pramsey" \ pts2.shp
results in one success and then errors, one per record it seems:
ERROR 1: HTTP error code : 400 ERROR 1: RunSQL Error Message:HTTP error code : 400 ERROR 1: Error returned by server : relation "pts_tmp_cartodb_id_seq" does not exist
I'm wondering if this has something to do with the table creation in RunDeferredCreationIfNecessary which both creates a
serial column and then also creates and associates a sequence. Thought maybe that doesn't matter and we just get some orphaned sequences.