[PostGIS] #5856: Could not add geog_brin_inclusion_merge to > brin_geography_inclusion_ops class: null value in column "refobjid" of relation

[PostGIS]

#5856: Could not add geog_brin_inclusion_merge to > brin_geography_inclusion_ops
class: null value in column "refobjid" of relation
---------------------+---------------------------
 Reporter:  robe     |      Owner:  robe
     Type:  defect   |     Status:  assigned
 Priority:  medium   |  Milestone:  PostGIS 3.5.3
Component:  upgrade  |    Version:  3.4.x
 Keywords:           |
---------------------+---------------------------
 From https://lists.osgeo.org/pipermail/postgis-
 devel/2025-March/030474.html

 ----

 After upgrading to postgresql-17-postgis-3-3.5.2+dfsg-1.pgdg120+1, I got
 this:

 # ALTER EXTENSION postgis UPDATE;
 DEBUG:  executing extension script for "postgis" update from version
 '3.5.0' to 'ANY'
 DEBUG:  executing extension script for "postgis" update from version 'ANY'
 to '3.5.2'
 ERROR:  Could not add geog_brin_inclusion_merge to
 brin_geography_inclusion_ops class: null value in column "refobjid" of
 relation "pg_depend" violates not-null constraint
 CONTEXT:  PL/pgSQL function inline_code_block line 219 at RAISE

 Due to:

 # SELECT n.oid FROM pg_catalog.pg_opclass AS n WHERE opcname =
 'brin_geography_inclusion_ops';
 (0 rows)

 This is an instance running pg17.4 (having just been upgraded from 17.2),
 which was pg_upgraded from 16.4 on 2024-10-12 (and previously from earlier
 versions).

 Also, the data dir was originally initdb'd under centos (7, and probably
 earlier versions before that), and most recently migrated to debian (with
 the requisite reindex).

 In november, it was upgraded from: postgresql-17-postgis
 3.4.3+dfsg-2.pgdg120+1 to 3.5.0+dfsg-1.pgdg120+1.  It looks like we have
 one other instance which will hit the same problem.

 --
 Justin

 ----
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5856>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.