[OSM-dev] osm2pgsql

Dave Stubbs osm.list at randomjunk.co.uk
Tue Jul 29 11:15:20 BST 2008


On Tue, Jul 29, 2008 at 11:00 AM, Walter Lorenzetti
<lorenzetti at faunalia.it> wrote:
> Hi list,
>
> I'm a newby on osm and I'd like suggest a little modification for
> osm2pgsql python application
> if possible add a constran of type PRIMARY KEY for every osm_id columns
> in every tables that
> osm2pqsql builds in db? This request is for Qgis software that requires
> a primary int4 column
> for loads data
>


There are actually duplicate osm_ids in this column at the moment. If
you really want it, then there's nothing to stop you tacking the
constraint on to the end of your import script -- you can figure out
how to resolve the contraint violations. But the easiest fix for your
problem would be to just add an extra column -- again, nothing to stop
you doing this after osm2pgsql has run.

Dave




More information about the dev mailing list