Problem to Upgrade from 3.2.3 to 3.4.0

[Arnaud Vandecasteele]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240214/697b5ac1/attachment.htm>