geog_brin_inclusion upgrade issue
lr at pcorp.us
lr at pcorp.us
Sat Mar 15 17:20:14 PDT 2025
Justin,
We discussed this on PostGIS IRC, and decided it's better to provide a
standalone script to fix a broken brin install instead of trying to fold it
in.
Can you try installing this SQL script.
https://git.osgeo.org/gitea/postgis/postgis/raw/commit/890833a97846218562016
5645d368bf044b33fa7/utils/fix_brin.sql
Still a WIP and I haven't had a chance to try to break my postgis install to
fully test it.
Try running the above script on one of your databases that can't be
upgraded.
Then after, run
SELECT postgis_extensions_upgrade();
A cleaner would have been for us to do a CREATE IF NOT EXISTS, but sadly
PostgreSQL doesn't support that construct for operators and operator
classes. Hopefully it will in the future.
Hopefully this works,
Regina
More information about the postgis-devel
mailing list