[postgis-tickets] [PostGIS] #5341: debbie failing on raster upgrade from 3.2, 3.1 to 3.4

[PostGIS]

#5341: debbie failing on  raster upgrade from 3.2, 3.1 to 3.4
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 3.4.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Comment (by strk):

 The error `column "sqlerrm" does not exist (42703)` suggests a bug in the
 version of PostGIS that your test ends up loading, which for an upgrade-
 path of `unpackaged3.3--:auto` is whatever version is in
 `${PG_SHAREDIR}/contrib/postgis-3.3`

 Now, with a quick look at postgis-3.3/rtpostgis.sql (for 3.3.3dev) I found
 this snippet which seems suspicious:
 {{{
     -- rasterize extent
     BEGIN
       _covrast := ST_AsRaster(_covextent, _scalex, _scaley, '8BUI', 1, 0,
 NULL, NULL, _skewx, _skewy);
       IF _covrast IS NULL THEN
         RAISE NOTICE 'Unable to create coverage raster. Cannot add
 coverage tile constraint: % (%)',
           SQLERRM, SQLSTATE;
         RETURN FALSE;
       END IF;
 }}}

 IN this case the SQLERRM is probably not set because the code is NOT in an
 exception handling block. The problem should then arise when the
 ST_AsRaster call performed by _add_raster_constraint_coverage_tile returns
 NULL
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5341#comment:6>
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.