PostGIS upgrade should not use temp tables as that is banned by some security policies

[robe]

Aiven proposed a solution using a temp function _postgis_upgrade_info() instead of a temp table _postgis_upgrade_info. I haven't tested the patch yet. Will affect all our upgrades so needs careful testing.

​https://github.com/postgis/postgis/pull/623

[robe]

Related issues this should solve:

RDS Mailing List issue: ​https://www.mail-archive.com/postgis-users@lists.osgeo.org/msg08353.html

Heroku also seems to have run into this error: ​https://stackoverflow.com/questions/54213361/update-postgis-extensions-on-heroku + ​https://trac.osgeo.org/postgis/ticket/4186 mention this error message

PostGIS Users list: ​https://lists.osgeo.org/pipermail/postgis-users/2020-May/044225.html

[Regina Obe <lr@…>]

In 87a815c/git:

Upgrade path patchfor address_standardizer_data_us
and minor fix to patch Closes #4974

PostGIS upgrade change to not use temp tables Closes #4975
Closes ​https://github.com/postgis/postgis/pull/623

Credits: Jan Katins (Aiven)

[strk]

Fine by me, but please update the CI badges on the wiki or we can't trust them

[strk]

I wonder if we could use the same approach for the dumper: #4975