[postgis-devel] r17001 broke upgrades

Sandro Santilli strk at kbt.io
Mon Nov 12 12:18:54 PST 2018


r17001 broke upgrades from 2.1, please see
https://drone.osgeo.org/postgis/postgis/1506

The error is:

  Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION '2.1.9'
  Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE TO '3.0.0dev'
  Died at ../run_test.pl line 1479.
   failed (Error encountered altering EXTENSION POSTGIS: /tmp/pgis_reg/regress_log)
  -----------------------------------------------------------------------------
  createlang: language "plpgsql" is already installed in database "postgis_reg"
  CREATE EXTENSION
  WARNING:  unpackaging raster
  WARNING:  PostGIS Raster functionality has been unpackaged
  HINT:  type `SELECT postgis_extensions_upgrade(); to finish the
  upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;
  ERROR:  operator argument types must be specified in ALTER OPERATOR FAMILY
  CONTEXT:  SQL statement "
          ALTER OPERATOR FAMILY gist_geometry_ops_nd USING gist
            ADD   OPERATOR        6        ~~=  ;
        "
  PL/pgSQL function inline_code_block line 26 at EXECUTE

The commit log references a GitHub pull request:
  https://github.com/postgis/postgis/pull/327

The Pull request does NOT reference a Trac ticket so I don't know
where else to report this issue.

Any committers please keep an eye on all bots. Travis alone does not
test all we want to test. Dronie is a great tester for upgrades...

--strk; 


More information about the postgis-devel mailing list