On Thu, Nov 6, 2008 at 10:42 AM, Milenko <[EMAIL PROTECTED]> wrote: > I thought able that, but this is a freshly loaded machine and I've only > ever downloaded this one copy of osmosis. Just for fun, I just did a file > search for osmosis-0.29 and found only the one directory that I've been > working in. > > > > -Jeremy > > > > > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Karl Newman > *Sent:* Thursday, November 06, 2008 1:16 PM > *To:* Milenko > *Cc:* [email protected] > *Subject:* Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue > > > > On Thu, Nov 6, 2008 at 10:15 AM, Milenko <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > I've been trying to get a local ROMA server working and I've run into > an issue with getting osmosis working. I've patched osmosis as per the > instructions on the wiki > (http://wiki.openstreetmap.org/index.php/Read_Only_Map_API), but when I > import data into the pgsql database, I'm still seeing statements in the db > log files that reference commands taken out by the patch. One specific > command is "UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM nodes > JOIN way_nodes ON way_nodes.node_id = nodes.id WHERE way_nodes.way_id = > ways.id)", seen in PostgreSqlWriter.java. I've verified that it's removed > from that file but it still runs when I try to import data. This command > takes days when trying to import the full planet. > > > > Anyone have any idea how this is happening? I've searched every file > in the osmosis directory and can't find that command, and yet it still > somehow gets run during the import. > > > > > > Any help would be greatly appreciated. > > > > -Jeremy > > Are you sure you're actually executing your patched version and not an > unpatched version that's somewhere on your path? > I don't know anything about the patch, but did you look in the script directory, at the pgsql_simple_load_0.5.sql file? That command is in there (spread over multiple lines, which is why a grep may not have found it).
Karl
_______________________________________________ Talk-us mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-us
