[postgis-tickets] [PostGIS] #4334: Can't upgrade with a view based on ST_AsMVTGeom

[PostGIS]

#4334: Can't upgrade with a view based on ST_AsMVTGeom
------------------------------------+---------------------------
  Reporter:  Algunenano             |      Owner:  Algunenano
      Type:  defect                 |     Status:  new
  Priority:  high                   |  Milestone:  PostGIS 3.0.0
 Component:  build/upgrade/install  |    Version:  2.4.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by Algunenano):

 > geometry_columns VIEW: We are already using CREATE OR REPLACE VIEW so we
 can drop this.

 I was wrong about this:
 {{{
 HINT:  type `SELECT postgis_extensions_upgrade(); to finish the upgrade.
 After upgrading, if you want to drop raster, run: DROP EXTENSION
 postgis_raster;
 ERROR:  cannot change data type of view column "f_table_schema" from
 character varying(256) to name
 }}}

 I'll see if we can we really need an unconditional DROP or we can only
 drop it when the old view is found (similar to the function).

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