[postgis-devel] Function Removal

Sandro Santilli strk at kbt.io
Wed Dec 16 12:28:27 PST 2020


On Wed, Dec 16, 2020 at 12:12:11PM -0800, Paul Ramsey wrote:
> > On Dec 16, 2020, at 12:10 PM, Regina Obe <lr at pcorp.us> wrote:
> >
> > The solution (though it may have changed with strk's voodoo) is, you add the
> > drop statement in
> > postgis_before_upgrade.sql
> 
> OK, have done that. Will see what nasty things happen.

It's not really a solution to the upgrade problem Paul was mentioning.
The upgrade problem is that if anyone has views using ST_MakePoint
will not be able to upgrade.

If you want to put this user path under automated testing add
such a view in the `create_upgrade_test_objects` subroutine
of `run_test.pl` (yes, we should really move creation of those
objects in a separate file).

Chances are it would be enough to drop the old one in
`postgis_after_upgrade.sql` instead of `postgis_before_upgrade.sql`
but it's best to test this.

--strk;



More information about the postgis-devel mailing list