[postgis-tickets] [PostGIS] #5497: Test double upgrades with locking views

[PostGIS]

#5497: Test double upgrades with locking views
-------------------------+---------------------------
 Reporter:  strk         |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.5.0
Component:  postgis      |    Version:  master
 Keywords:               |
-------------------------+---------------------------
 The bug reported in #5494 only affects running an upgrade procedure twice
 while a view holds back some deprecated function.

 This resulted in no bots ever catching it, which is a pity.
 This ticket is to improve the testsuite to also test this case.

 The double upgrade could re-use the existing pre-upgrade hooks to install
 the locking views, then run an ad-hoc test running an additional upgrade,
 and call all of this via run_test.pl --upgrade which would be doing the
 first upgrade.

 I've done this locally but would like to automate it somehow.

 I think running ALL tests would be overkill so this is really something we
 only want to do with an ad-hoc test
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5497>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.