[osmosis-dev] pgsimple/pgsnapshot possible bug

[Daniel Kaneider]

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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20130124/269c9eb8/attachment.html>