<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
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 <br>
<br>
<tt>UPDATE ways SET bbox = (</tt><tt><br>
</tt><tt> SELECT Envelope(Collect(geom))</tt><tt><br>
</tt><tt> FROM nodes JOIN way_nodes ON way_nodes.node_id =
nodes.id</tt><tt><br>
</tt><tt> WHERE way_nodes.way_id = ways.id</tt><tt><br>
</tt><tt>);</tt><tt><br>
</tt><br>
should be changed to <br>
<br>
<tt>UPDATE ways SET bbox = (<br>
SELECT <b>ST_Envelope</b>(<b>ST_Collect</b>(geom))<br>
FROM nodes JOIN way_nodes ON way_nodes.node_id = nodes.id<br>
WHERE way_nodes.way_id = ways.id<br>
);</tt><br>
<br>
This should apply also to the pg_simple script.<br>
<br>
Best,<br>
Daniel Kaneider<br>
<br>
<br>
<br>
<br>
</body>
</html>