Error upgrading from postgis 2.5.1 to PostGIS 3.0.1

[robe]

Get this error on my oldest PostGIS windows install.

When running

SELECT postgis_extensions_upgrade();  -- second call

ALTER EXTENSION postgis_raster ADD OPERATOR CLASS hash_raster_ops USING hash;
operator class hash_raster_ops does not exist for access method hash

[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

[strk]

It looks like those operators are advertised as being available since 2.1.0, why didn't you have them in your 2.5.x source ? Is that a PostgreSQL-version specific availability ?

[robe]

Just tried again upgrading from 2.5.5dev to 3.0.1 and seemd to work fine. Not sure what caused this.