Skip to content

relation country_osm_grid does not exist #450

@Epse

Description

@Epse

For starters, if this is the wrong place do let me know

When running the import-sql step, it eventually errors out as follows:

psql:/sql/parallel/building.sql:100: ERROR:  relation "country_osm_grid" does not exist
LINE 2:         FROM country_osm_grid country
                     ^
QUERY:  SELECT ST_Transform(country.geometry, 3857) AS geometry
        FROM country_osm_grid country
CONTEXT:  PL/pgSQL function osm_building_block_gen1() line 9 at FOR over SELECT rows

The very same building.sql previously had an issue with it being unable to find the zres functions. I edited the file to make it reference public.zres which did seem to resolve that issue.

We are running this on our own postgres server, not the included one, but it should be set up properly.
This is during import of Europe.

update, when editing the SQL file to use public.country_osm_grid_country it then errors at a ST_Transform function call that presumably also needs a public prefix. Is this even intended to make a separate schema?

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