[Tile-serving] [osm2pgsql-dev/osm2pgsql] Refuse to import if PostGIS's core procedures aren't updated. (Discussion #2140)

[ImreSamu]

 > This situation can be easily detected by parsing the string returned by SELECT PostGIS_Full_Version();


I do not recommend parsing the result of 'SELECT PostGIS_Full_Version();' as the text can change at any time, or there could be a localized (non-English) version installed, which would then not work.

If the warning is still important, I would rather suggest a comparison based on the PostgreSQL meta tables, although this may yield a different result than the PostGIS_Full_Version();


```sql

SELECT
  ae.name,
  installed_version,
  default_version,
  case when installed_version <> default_version 
    THEN 'need_to_upgrade'
    ELSE 'up_to_date'
  END AS upgrade_status
FROM pg_extension e
JOIN pg_available_extensions ae on extname = ae.name
WHERE extname='postgis'
;

  name   | installed_version | default_version | upgrade_status  
---------+-------------------+-----------------+-----------------
 postgis | 3.1.7             | 3.2.5           | need_to_upgrade
(1 row)

```

vs.

```sql
SELECT PostGIS_Full_Version();

                                           postgis_full_version
---------------------------------------------------------------------------------------------------
 POSTGIS="3.1.9 3.1.9" [EXTENSION] PGSQL="120" (procs need upgrade for use with PostgreSQL "140") 
 GEOS="3.5.0-CAPI-1.9.0 4392" PROJ="Rel. 6.3.1, February 10th, 2020" LIBXML="2.9.10" 
 LIBJSON="0.17" LIBPROTOBUF="1.4.1" (core procs from "3.1.7 3.1.7" need upgrade)
 
```




-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2140#discussioncomment-8485846
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2140/comments/8485846 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240215/127bec13/attachment.htm>