[postgis-devel] Postgis upgrade issues with new PostgreSQL minor versions

[Regina Obe]

Why are you using 3.0.0? – that was released years ago.

 

Please use 3.0.7 which should have a fix for this.  It might not be available on your system just yet, but should be sometime next week.

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Kirill Reshke
Sent: Thursday, August 18, 2022 5:40 AM
To: postgis-devel at lists.osgeo.org
Subject: [postgis-devel] Postgis upgrade issues with new PostgreSQL minor versions

 

 

Hi hackers!

 

We have faced an issue while upgrading postgis extension on one of our cluster. We upgrade from 2.5.2 version to 3.0.0 to be precise. PG version in 11.17

 

The error we get is:

<cut>/db1 M # alter extension postgis_tiger_geocoder update TO "3.0.0";
ERROR:  55000: function setsearchpathforinstall(character varying) is not a member of extension "postgis_tiger_geocoder"
DETAIL:  An extension is not allowed to replace an object that it does not own.
LOCATION:  recordDependencyOnCurrentExtension, pg_depend.c:187
Time: 80.574 ms
The reason is, that after this commit https://github.com/postgres/postgres/commit/f52d2fbd8c62f667191b61228acf9d8aa53607b9
extension are not allowed to replace objects not belonging to the extension.
After debuging with gdb, we have find out than postgis_tiger_geocoder do this sql command while 
upgrade:

ALTER EXTENSION postgis_tiger_geocoder DROP FUNCTION setsearchpathforinstall(character varying);
which erase dependency between postgis_tiger_geocoder ext and setsearchpathforinstall function, reasoning in upgrade failure.
So, is this a well-known bug? how we can get rid of this? i will try to propose a patch for it, if this is unknown bug or there is no fix.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20220819/4b992261/attachment.htm>