[postgis-devel] jsonb leftovers on upgrade

Regina Obe lr at pcorp.us
Fri Jun 28 13:35:41 PDT 2019

Hmm?  Bots using json?

Do any of our bots test installing from unpackaged?

-----Original Message-----
From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Sandro Santilli
Sent: Friday, June 28, 2019 3:55 AM
To: postgis-devel at lists.osgeo.org
Subject: [postgis-devel] jsonb leftovers on upgrade

I can get a regression failure with this call:

    regress/run_test.pl -v \
        --extension \
        --upgrade-path unpackaged--3.0.0dev

The failures are:

  +unexpected probin|json:/usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-install/lib/postgis-3
  +unexpected probin|jsonb:/usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-install/lib/postgis-3
  +unexpected probin|st_asgeojson:/usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-install/lib/postgis-3
  ERROR:  cannot drop extension postgis because other objects depend on it
  DETAIL:  function json(geometry) depends on type geometry
           function jsonb(geometry) depends on type geometry
           cast from geometry to json depends on type geometry
           cast from geometry to jsonb depends on type geometry
  HINT:  Use DROP ... CASCADE to drop the dependent objects too.


  1. Can anyone reproduce ?
  2. Why none of our bots catches this ?!
     Are we out of bots using json?


  ()   Free GIS & Flash consultant/developer
  /\   https://strk.kbt.io/services.html
postgis-devel mailing list
postgis-devel at lists.osgeo.org

More information about the postgis-devel mailing list