Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#4975 closed defect (fixed)

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

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS 3.2.0
Component: build Version: 2.5.x -- EOL
Keywords: Cc:

Description

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

Change History (4)

comment:2 by Regina Obe <lr@…>, 3 years ago

Resolution: fixed
Status: newclosed

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)

comment:3 by strk, 3 years ago

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

comment:4 by strk, 3 years ago

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

Version 0, edited 3 years ago by strk (next)
Note: See TracTickets for help on using tickets.