[postgis-tickets] [PostGIS] #5222: extension "postgis_raster" has no installation script nor update path for version "unpackaged"

[PostGIS]

#5222: extension "postgis_raster" has no installation script nor update path for
version "unpackaged"
-----------------------+----------------------------
  Reporter:  marc3932  |      Owner:  robe
      Type:  patch     |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.2.3
 Component:  raster    |    Version:  3.2.x
Resolution:            |   Keywords:  postgis_raster
-----------------------+----------------------------
Description changed by marc3932:

Old description:

> ------------------------------------
>
> Platform:
>
> Windows Server 2019 Standard
>
> PostgreSQL 11.17 x64
>
> PostGIS 3.2.2
>
> ------------------------------------
>
> {{{
> SELECT postgis_full_version();
> }}}
>
> ''/*
>
> "POSTGIS=""3.2.2 3.2.2"" [EXTENSION] PGSQL=""110""
> GEOS=""3.10.3-CAPI-1.16.1""
>
> PROJ=""7.2.1"" GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not
> found""
>
> LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0
> (Internal)""
>
> **RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!]
>
> (raster procs from ""2.5.2 r17328"" need upgrade)"**
>
> */
> ''
>
> ------------------------------------
>
> {{{
> ALTER EXTENSION postgis UPDATE;
> }}}
>
> ''/*
>
> NOTICE:  version "3.2.2" of extension "postgis" is already installed
>
> ALTER EXTENSION
>
> Query returned successfully in 512 msec.
>
> */
> ''
>
> ------------------------------------
>
> {{{
> SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';
> }}}
>
> ''1 | "postgis" | "3.2.2" | "3.2.2" | "PostGIS geometry and geography
> spatial types and functions" |''
>
> ------------------------------------
>
> {{{
> SELECT postgis_extensions_upgrade();
> }}}
>

> ''/*
>
> **NOTICE:  Extension postgis_sfcgal is not available or not packagable
> for some reason**
>
> **NOTICE:  Packaging extension postgis_raster
>
> **ERROR:  extension "postgis_raster" has no installation script nor
> update path for version "unpackaged"**
>
> **CONTEXT:  SQL statement "**
>
> **CREATE EXTENSION postgis_raster SCHEMA public
> VERSION unpackaged;**
>
> **ALTER EXTENSION postgis_raster UPDATE TO "3.2.2"**
>
> "
> PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE
> SQL state: 22023
>
> */
>
> ------------------------------------
>
> How can I upgrade to postgis_raster 3.2.2 ???
>
> If I don't have any raster data, then how do I remove pg_raster ???
>
> Thanks,
>
> Marcelo Marques
>
> | Principal Product Engineer | Esri | www.esri.com

New description:

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

 Platform:

 Windows Server 2019 Standard

 PostgreSQL 11.17 x64

 PostGIS 3.2.2

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

 {{{
 SELECT postgis_full_version();
 }}}

 ''

 "POSTGIS=""3.2.2 3.2.2"" [EXTENSION] PGSQL=""110""
 GEOS=""3.10.3-CAPI-1.16.1""

 PROJ=""7.2.1"" GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not
 found""

 LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0
 (Internal)""

 **RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!]

 (raster procs from ""2.5.2 r17328"" need upgrade)"**

 ''

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

 {{{
 ALTER EXTENSION postgis UPDATE;
 }}}

 ''

 NOTICE:  version "3.2.2" of extension "postgis" is already installed

 ALTER EXTENSION

 Query returned successfully in 512 msec.

 ''

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

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

 ''1 | "postgis" | "3.2.2" | "3.2.2" | "PostGIS geometry and geography
 spatial types and functions" |''

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

 {{{
 SELECT postgis_extensions_upgrade();
 }}}


 ''

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

 **NOTICE:  Packaging extension postgis_raster

 **ERROR:  extension "postgis_raster" has no installation script nor update
 path for version "unpackaged"**

 **CONTEXT:  SQL statement "**

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

 **ALTER EXTENSION postgis_raster UPDATE TO "3.2.2"**

 "
 PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE
 SQL state: 22023

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

 How can I upgrade to postgis_raster 3.2.2 ???

 If I don't have any raster data, then how do I remove pg_raster ???

 Thanks,

 Marcelo Marques

 | Principal Product Engineer | Esri | www.esri.com

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