On Wed, Dec 03, 2008 at 11:32:09AM -0500, Matthias Julius wrote: > I am attempting to follow the trend and set up my own ROMA server. > Unfortunately that does not goes as smooth as I would wish. > > I am following the instructions at > http://wiki.openstreetmap.org/index.php/Read_Only_Map_API > > When applying the database schema psql complains while creating an > index: > > ERROR: column "bbox" does not exist
The bbox column is obsolete - its not necessary for the SQL of ROMA
and creating the bbox on import runs forever (as it does a full table
scan on the nodes table per way)
> Then, on the planet import osmosis dies with:
>
> ERROR: index "idx_ways_bbox" does not exist
>
> Is there a trick that is not mentioned on the wiki page?
>
> One little discrepancy I noticed is that osmosis-0.29-patch is
> patching script/pgsql_simple_schema.sql contrary to the listing on the
> wiki.
It should patch it - as it patches osmosis. So the bbox column should not be
created using the patches schema - and the patched (and dont forget to
rebuild) osmosis shouldnt need it ...
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
Description: Digital signature
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
