Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

relation country_osm_grid does not exist #450

Open
Epse opened this issue Oct 28, 2024 · 0 comments
Open

relation country_osm_grid does not exist #450

Epse opened this issue Oct 28, 2024 · 0 comments

Comments

@Epse
Copy link

Epse commented Oct 28, 2024

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant