Hi,
I did some import of OSM data into a Postgresql 9.2 DB using osmosis
0.41. The pgsnapshot_load script stopped since some function could not
be found (Envelope,Collect). If I am not wrong then
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
);
should be changed to
UPDATE ways SET bbox = (
SELECT *ST_Envelope*(*ST_Collect*(geom))
FROM nodes JOIN way_nodes ON way_nodes.node_id = nodes.id
WHERE way_nodes.way_id = ways.id
);
This should apply also to the pg_simple script.
Best,
Daniel Kaneider
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
