[postgis-tickets] [PostGIS] #4186: Unable to upgrade from PostGIS 2.4.3 to 2.4.4

[PostGIS]

#4186: Unable to upgrade from PostGIS 2.4.3 to 2.4.4
-------------------------+----------------------------
  Reporter:  Rikiar      |      Owner:  pramsey
      Type:  defect      |     Status:  closed
  Priority:  blocker     |  Milestone:  PostGIS 2.4.6
 Component:  postgis     |    Version:  2.4.x
Resolution:  worksforme  |   Keywords:  Upgrade, 2.4.3
-------------------------+----------------------------

Comment (by msakrejdasfdc):

 I think the `ALTER EXTENSION` error may have to do with our usage of
 pgextwlist, so I tried running the update as a superuser. I was able to
 reproduce the original error, and then in investigating further, I ran
 across this:

 {{{
 => select null::box2d;
 ERROR:  type "box2d" is only a shell
 LINE 1: select null::box2d;
                      ^
 }}}

 however, fully-qualifying the type does seem to work:

 {{{
 => select null::public.box2d;
  box2d
 -------

 (1 row)
 }}}

 the search_path does include the public schema:

 {{{
 => show search_path;
    search_path
 -----------------
  "$user", public
 (1 row)

 }}}

 Any ideas?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4186#comment:9>
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.