Hi, I have a problem with my postgis installation. I have updated my packages (see below for package details) and since then I have an error message when using one function :
*ERROR: A stored procedure tried to use deprecated C function 'pgis_geometry_union_finalfn'* No big deal I thought, a simple *SELECT postgis_extensions_upgrade();* should resolve the problem. So I did this and everything went well (I thought) : *Upgrade completed, run SELECT postgis_full_version(); for details* I tried again to import my data and I got the same message again* (**ERROR: A stored procedure tried to use deprecated C function 'pgis_geometry_union_finalfn')* So I ran the SELECT postgis_full_version(); query that returns: *POSTGIS="3.4.0 0874ea3" [EXTENSION] PGSQL="140" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org <https://cdn.proj.org> USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db" LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" (core procs from "3.2.3 2f97b6c" need upgrade)* It seems that the upgrade was not really applied. I then checked the default postgis version : *SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name = 'postgis'; name | default_version | installed_version ---------+-----------------+------------------- postgis | 3.2.3 | 3.2.3* The default_version is still 3.2.3 and I suppose this is why postgis doesn't really upgrade. It only keeps the same version. Do you know how I could resolve this issue ? Thanks for your help, Regards Arnaud ************************ ******** *Packages details - Ubuntu 22.04.3 LTS* *apt policy postgispostgis: Installed: 3.4.0+dfsg-3~jammy0 Candidate: 3.4.0+dfsg-3~jammy0 Version table: *** 3.4.0+dfsg-3~jammy0 500 500 https://ppa.launchpadcontent.net/ubuntugis/ppa/ubuntu <https://ppa.launchpadcontent.net/ubuntugis/ppa/ubuntu> jammy/main amd64 Packages 100 /var/lib/dpkg/status 3.2.0+dfsg-1ubuntu1 500 500 http://europe-southwest1-a.gce.clouds.archive.ubuntu.com/ubuntu <http://europe-southwest1-a.gce.clouds.archive.ubuntu.com/ubuntu> jammy/universe amd64 Packages* -- -------------------------------------------------------------------- Arnaud Vandecasteele