From b52504e9beda2aff5d328f3ad54cd975067f10bb Mon Sep 17 00:00:00 2001 From: User for running Openstreetmap-things Date: Thu, 2 Jun 2016 17:28:49 +0200 Subject: [PATCH] add explicit cast, else postgresql 9.5 will break (9.3 works fine) --- scripts/osmbuildings-json-generator.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/scripts/osmbuildings-json-generator.pl b/scripts/osmbuildings-json-generator.pl index a9b28f4..3a39357 100755 --- a/scripts/osmbuildings-json-generator.pl +++ b/scripts/osmbuildings-json-generator.pl @@ -177,7 +177,7 @@ foreach $xtable ('planet_osm_polygon1', 'planet_osm_polygon2', 'planet_osm_line' exit(1); } my $sth2 = $dbh->prepare("select ST_X(points) as x, ST_Y(points) as y" - . " from (select ST_astext((ST_dumppoints(ST_transform(?, 4326))).geom) as points) as points"); + . " from (select ST_astext((ST_dumppoints(ST_transform(geometry(?), 4326))).geom) as points) as points"); my $sth4 = $dbh->prepare("select (ST_dumprings(?)).geom as rings"); while ($row = $sth->fetchrow_hashref()) { if ($xtable eq 'planet_osm_polygon1') { -- 2.25.1