[postgis-devel] ERROR: operator class "brin_geography_inclusion_ops" does not exist for access method "brin"

[Justin Pryzby]

On Wed, Oct 13, 2021 at 09:18:33AM -0400, Regina Obe wrote:
> 1) Yes you should always run postgis_extensions_upgrade() after any patch
> level update to postgis

I've now added this to my upgrade scripts.

I should also add that up to now I've been upgrading postgis by running
postgis_upgrade.sql.  I'm sure I should have switched to using extensions, but
I missed that last year before upgrading everying to pg13, which no longer
supports "FROM UNPACKAGED".  So eventually I have to clean it up.

It looks like postgis_extensions_upgrade() handles that for postgis, which is
great.  Thanks for that.

> You shouldn't need to comment out the operator class.  The error suggests 
> " ERROR:  operator class "brin_geography_inclusion_ops" does not exist for
> access method "brin"
> CONTEXT:  SQL statement "ALTER EXTENSION postgis ADD OPERATOR CLASS
> brin_geography_inclusion_ops USING brin"
> 
> its failing cause you have no operator class brin.
> So it's failing because it's trying to add the non-existent operator class
> to the postgis extension.

This is a bit beyond the limits of my understanding.

The server which has this error has:

 brin   | brin_geography_inclusion_ops   | &&(gidx,gidx)                                               |        3 | search
 brin   | brin_geography_inclusion_ops   | &&(geography,gidx)                                          |        3 | search
 brin   | brin_geography_inclusion_ops   | &&(gidx,geography)                                          |        3 | search

Thanks,
-- 
Justin