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

[Justin Pryzby]

On Mon, Oct 25, 2021 at 02:50:15AM -0400, Regina Obe wrote:
> > 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

> Okay I found the ticket where I ran into the same issue.
> Looks like it was closed cause it was deemed only an issue for 9.3
> 
> https://trac.osgeo.org/postgis/ticket/3633
> 
> Although from your above, it looks like you already have this operator
> class, but I'm not sure what command you used to generate that search
> result.

It's \dAo

> What happens if you try to do this in that database:
> ALTER EXTENSION postgis ADD OPERATOR CLASS brin_geography_inclusion_ops USING brin;

ts=# ALTER EXTENSION postgis ADD OPERATOR CLASS brin_geography_inclusion_ops USING brin;
ERROR:  extension "postgis" does not exist

Thanks for looking at this.

-- 
Justin