hello, i have noticed a strange osm2pgsql behavior, when you import planet without a slim option, it does not create the same tables as with using --slim, which results you cannot apply any changes later - is it a bug?
---------------> without slim g...@osm:~/osm2pgsql$ time 7z x -so ../planet-090708.osm.bz2 | ./osm2pgsql - osm2pgsql SVN version 0.66-16445 Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point 7-Zip 4.58 beta Copyright (c) 1999-2008 Igor Pavlov 2008-05-05 p7zip Version 4.58 (locale=C,Utf16=off,HugeFiles=on,4 CPUs) Processing archive: ../planet-090708.osm.bz2 Extracting planet-090708.osmSetting up table: planet_osm_line Setting up table: planet_osm_polygon Setting up table: planet_osm_roads Mid: Ram, scale=100 Reading in file: - ----------------> with slim g...@osm:~/osm2pgsql$ time 7z x -so ../planet-090708.osm.bz2 | ./osm2pgsql --slim -C 18000 - osm2pgsql SVN version 0.66-16445 7-Zip 4.58 beta Copyright (c) 1999-2008 Igor Pavlov 2008-05-05 p7zip Version 4.58 (locale=C,Utf16=off,HugeFiles=on,4 CPUs) Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point Processing archive: ../planet-090708.osm.bz2 Extracting planet-090708.osmSetting up table: planet_osm_line Setting up table: planet_osm_polygon Setting up table: planet_osm_roads Mid: pgsql, scale=100, cache=18000MB, maxblocks=2304001*8192 Setting up table: planet_osm_nodes *** WARNING: intarray contrib module not installed *** The resulting database will not be usable for applying diffs. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes" Setting up table: planet_osm_ways NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways" Setting up table: planet_osm_rels NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels" Reading in file: - _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev