Skip to content

psql error "relation "details_poly" does not exist" #384

@ramunasd

Description

@ramunasd

2022-11-04 21:04:14 +0200 [warn]: #0 [input_postgresql_log] pattern not matched: "2022-11-04 21:04:14.498 EET [445791] osm@osm ERROR: relation "details_poly" does not exist at character 251"
2022-11-04 21:04:14 +0200 [warn]: #0 [input_postgresql_log] pattern not matched: "2022-11-04 21:04:14.498 EET [445791] osm@osm STATEMENT: SELECT ((SELECT ST_AsMVT(q,'detail_poly',4096,'geom',NULL) AS data FROM (SELECT gid AS gid, ST_AsMVTGeom(geom, ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) AS geom, kind AS kind FROM details_poly WHERE geom && ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) AS q)||(SELECT ST_AsMVT(q,'detail_line',4096,'geom',NULL) AS data FROM (SELECT gid AS gid, ST_AsMVTGeom(geom,ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) AS geom, kind AS kind, highway FROM details_line WHERE geom && ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) AS q)||(SELECT ST_AsMVT(q,'power_l',4096,'geom',NULL) AS data FROM (select osm_id as gid ,st_asmvtgeom(way,ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) as geom ,case when voltage = '330000' then '330' when voltage = '110000' then '110' when voltage = '35000' then '35' end as voltage from planet_osm_line where way && ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857) and power = 'line') AS q)||(SELECT ST_AsMVT(q,'power_p',4096,'geom',NULL) AS data FROM (select osm_id as gid ,st_asmvtgeom(way,ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857)) as geom from planet_osm_point where way && ST_MakeEnvelope(2.5254794141906723e+06,7.454138997332763e+06,2.5260909104168713e+06,7.45475049355896e+06,3857) and power = 'tower') AS q)) AS data"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions