[postgis-devel] Force to Update SQL Function

Sandro Santilli strk at kbt.io
Sun Aug 13 13:48:48 PDT 2023


On Tue, Aug 08, 2023 at 11:27:32PM -0400, Regina Obe wrote:
> When we change a function like adding a new argument, we drop the old
> version of the function before we create the new.
> 
> Those drops are put in this file:
> 
> https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/postgis/postgi
> s_before_upgrade.sql
> 
> the final postgis extension upgrade scripts includes that
> postgis_before_upgrade.sql script
> 
> as you see on this line:
> 
> https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/extensions/pos
> tgis/Makefile.in#L119

At the moment we have a smarter way to deal with this which is
a comment with form:

  -- Replaces previous_signature(arg1, arg2) deprecated in x.y.z

That comment is used by the upgrade generator utils/create_upgrade.pl
to automatically perform a drop while still handling the case in which
a database object uses the old signature and reporting this occurrence
to user at `postgis_full_version()` time.

--strk;




More information about the postgis-devel mailing list