[postgis-tickets] [PostGIS] #5236: ERROR: type "raster" is only a shell

[PostGIS]

#5236: ERROR:  type "raster" is only a shell
----------------------------+---------------------------
 Reporter:  marc3932        |      Owner:  pramsey
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 3.2.4
Component:  postgis         |    Version:  3.2.x
 Keywords:  postgis_raster  |
----------------------------+---------------------------
 -- Platform:

 {{{
 Windows Server 2019
 PostgreSQL 12.12
 Postgis 3.2.3
 }}}


 {{{
 SELECT postgis_full_version();
 }}}


 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""120""
 GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1""
 LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0
 (Internal)""
 (raster procs from ""2.4.4 r16526"" need upgrade)"

 **NOTE: postgis 3.2.3 and raster 2.4.4
 **

 **-- Upgrade the Postgis Extensions**

 {{{
 SELECT postgis_extensions_upgrade();
 }}}

 NOTICE:  Packaging extension postgis_raster

 **ERROR:  type "raster" is only a shell**

 CONTEXT:  SQL statement

 **"CREATE EXTENSION postgis_raster SCHEMA public VERSION unpackaged;**

 **ALTER EXTENSION postgis_raster UPDATE TO "3.2.3""**

 PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE

 SQL state: 42704

 **QUESTIONS:**

 Why the extension upgrade returns "ERROR:  type "raster" is only a shell"
 ???

 Is this another bug ???

 Is there any other workaround for this issue besides
 "uninstall_rtpostgis.sql" described below ???

 **--SOLUTION: **

 -- uninstall postgis_raster

 {{{
 psql

 \c rev

 \i 'C:\\Program
 Files\\PostgreSQL\\12\\share\\contrib\\postgis-3.2\\uninstall_rtpostgis.sql'
 }}}


 {{{
 SELECT postgis_extensions_upgrade();
 }}}


 "Upgrade completed, run SELECT postgis_full_version(); for details"

 NOTICE:  Extension postgis_raster is not available or not packagable for
 some reason

 NOTICE:  Extension postgis_sfcgal is not available or not packagable for
 some reason

 NOTICE:  Extension postgis_topology is not available or not packagable for
 some reason

 NOTICE:  Extension postgis_tiger_geocoder is not available or not
 packagable for some reason

 Successfully run. Total query runtime: 144 msec.
 1 rows affected.


 {{{
 SELECT postgis_full_version();
 }}}


 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""120""
 GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1""
 LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0
 (Internal)"""


 {{{
 CREATE EXTENSION postgis_raster;
 }}}

 CREATE EXTENSION

 Query returned successfully in 227 msec.


 {{{
 SELECT postgis_full_version();
 }}}


 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""120""
 GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1""
 GDAL=""GDAL 3.4.3, released 2022/04/22 GDAL_DATA not found""
 LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0
 (Internal)"" RASTER"


 {{{
 SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';
 }}}

 "name"  "default_version"       "installed_version"     "comment"

 "postgis"       "3.2.3" "3.2.3" "PostGIS geometry and geography spatial
 types and functions"

 "postgis_raster"        "3.2.3" "3.2.3" "PostGIS raster types and
 functions"

 {{{
 DROP EXTENSION postgis_raster;
 }}}


 DROP EXTENSION

 Query returned successfully in 94 msec.

 ------------------------------------------------------

 I appreciate the assistance to clarify my questions.

 Thanks,

 Marcelo Marques | Principal Product Engineer | Esri - www.esri.com |
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5236>
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.