Opened 14 months ago

Closed 4 months ago

#5550 closed defect (fixed)

Repackaging raster in a sandboxed system fails

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.5.0
Component: upgrade/soft Version: 3.0.x
Keywords: pgextwlist Cc: wodan

Description

It looks like re-packaging raster after upgrade from 2.x is not possible in a sandboxed system.

See https://trac.osgeo.org/postgis/ticket/5545#comment:6

Change History (4)

comment:1 by strk, 14 months ago

CI coverage of sandboxed systems ticket filed: #5566

comment:2 by strk, 13 months ago

Cc: wodan added
Component: postgisupgrade/soft
Milestone: PostGIS Fund MePostGIS 3.5.0
Owner: changed from pramsey to strk

As of commit [5c37f97329db3fc67b542d12ac31d73ad2f71c5a/git] we have CI under pgextwlist and it shows no problems with upgrade from 2.5 thanks to the included [e2bf40c322c8805ca13e5a270b98b2793ee436a3/git] commit changing ownership of functions during upgrade.

I would ask Dan Worthman to confirm this problem is now fixed

Original problem was:

postgres=> SELECT postgis_extensions_upgrade();
NOTICE:  Updating extension postgis from 3.2.3 to 3.3.2
NOTICE:  Packaging extension postgis_raster
ERROR:  Trying to add VIEW raster_columns to postgis_raster, got must be owner of extension postgis_raster (42501)

comment:3 by strk, 4 months ago

According to comment:2 we have no confirmation of this problem in the master branch so I'd close this ticket once a NEWS item about it is added

comment:4 by Sandro Santilli <strk@…>, 4 months ago

Resolution: fixed
Status: newclosed

In 861d615/git:

Add item about fix of sandboxed system upgrades from 2.x times

Closes #5550

The actual commit fixing it was e2bf40c32

Note: See TracTickets for help on using tickets.