[Tile-serving] [openstreetmap/osm2pgsql] New PostGIS check breaks CockroachDB compatibility (#1412)

[Pierce Staab]

I totally understand being a PostreSQL/PostGIS importer, but it looks like that CockroachDB specifically tries to be compatible with OSM. In fact, they have a [whole page](https://www.cockroachlabs.com/docs/stable/migrate-from-openstreetmap.html) on how to get OSM running on it. As for the specif error, before it passed with a version of `3.0.1` for the PostGIS extension version. With the new check it's failing on getting the PostGIS version, the query returns nothing. Looks like cockroach has 3 entries in the `pg_extension` schema: `geography_colums`, `Shows all defined geography columns. Matches PostGIS' geography_columns functionality.` `geometry_columns`, `Shows all defined geometry columns. Matches PostGIS' geometry_columns functionality.` and `spatial_ref_sys`, `Shows all defined Spatial Reference Identifiers (SRIDs). Matches PostGIS' spatial_ref_sys table.` I would guess simply tweaking this check to work with both postres and cockroach is all that's needed to fix this. I'm pretty new to all this but I'll see if I can maybe figure out a query that works for both cockroach and postgres.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1412#issuecomment-774047476
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210205/6f6116be/attachment.htm>