[PostGIS] #5856: Could not add geog_brin_inclusion_merge to > brin_geography_inclusion_ops class: null value in column "refobjid" of relation
PostGIS
trac at osgeo.org
Sun Mar 2 13:46:57 PST 2025
#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.
More information about the postgis-tickets
mailing list