[postgis-tickets] [PostGIS] #4668: Error upgrading from postgis 2.5.1 to PostGIS 3.0.1

[PostGIS]

#4668: Error upgrading from postgis 2.5.1 to PostGIS 3.0.1
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 2.5.5
 Component:  build/upgrade/install  |    Version:  2.5.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by robe):

 Had to manually install this section of rtpostgis.sql script


 {{{
 -------------------------------------------------------------------
 -- HASH operators
 -------------------------------------------------------------------

 -- call PostgreSQL's hashvarlena() function
 -- Availability: 2.1.0
 CREATE OR REPLACE FUNCTION raster_hash(raster)
         RETURNS integer
         AS 'hashvarlena'
         LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE;

 -- use raster_hash() to compare
 -- Availability: 2.1.0
 CREATE OR REPLACE FUNCTION raster_eq(raster, raster)
         RETURNS bool
         AS $$ SELECT raster_hash($1) = raster_hash($2) $$
         LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;

 -- Availability: 2.1.0
 CREATE OPERATOR = (
         LEFTARG = raster, RIGHTARG = raster, PROCEDURE = raster_eq,
         COMMUTATOR = '=',
         RESTRICT = eqsel, JOIN = eqjoinsel
 );

 -- Availability: 2.1.0
 CREATE OPERATOR CLASS hash_raster_ops
         DEFAULT FOR TYPE raster USING hash AS
         OPERATOR        1       = ,
         FUNCTION        1       raster_hash (raster);

 }}}

 before could run upgrade again

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