[postgis-tickets] [PostGIS] #3919: Broken upgrade: ERROR: function geometry_hash(geometry) does not exist

[PostGIS]

#3919: Broken upgrade: ERROR:  function geometry_hash(geometry) does not exist
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  assigned
 Priority:  blocker  |  Milestone:  PostGIS 2.5.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 From our good Dronie bot:
 https://drone.osgeo.org/postgis/postgis/632
 {{{
 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION '2.1.2'
 Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
 TO '2.5.0dev'
 Died at run_test.pl line 1423.
  failed (Error encountered altering EXTENSION POSTGIS:
 /tmp/pgis_reg/regress_log)
 -----------------------------------------------------------------------------
 createlang: language "plpgsql" is already installed in database
 "postgis_reg"
 CREATE EXTENSION
 ERROR:  function geometry_hash(geometry) does not exist
 CONTEXT:  SQL statement "
     CREATE OPERATOR CLASS hash_geometry_ops
         DEFAULT FOR TYPE geometry USING hash AS
     OPERATOR    1   = ,
     FUNCTION    1   geometry_hash(geometry);
     "
 PL/pgSQL function inline_code_block line 4 at EXECUTE statement
 -----------------------------------------------------------------------------
 }}}

 r16058 was the first failing commit.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3919>
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.