Re: [PATCH] RFC: new_oid_hook, to let an extension propose catalog OIDs

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: RekGRpth <rekgrpth(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] RFC: new_oid_hook, to let an extension propose catalog OIDs
Date: 2026-10-31 00:42:27
Message-ID: auU5c0optgtCkwJx@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 28, 2026 at 01:25:03PM +0500, RekGRpth wrote:
> - Is a hook here acceptable at all, or would you rather extend the
> binary-upgrade mechanism ("the next OID for this catalog is X") to
> normal operation?

I don't like the idea of a hook for that. That seems clumsy as it
requires the hook to be loaded on the target server.

If you wish to fix an OID in time for a custom catalog, cannot it be
something that could also be done on the extension side? Or is that
really a case common enough out there that it justifies an in-core
facility to support in core? If that were common enough, not having
to duplicate the same facilities across a few dozen extension could
make sense, yes, though I doubt that a hook is the adapted interface
for that. Your idea of a binary-upgrade-like-mechanism similar in
some way to the existing object dumping for extensions would make more
sense, the idea being to ease the move of the extension object *across
major versions*.

> Co-Authored-By: Claude Opus 5.5 <noreply(at)anthropic(dot)com>

Okay....
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ahmed 2026-10-31 01:40:03 Re: Fix cumulative WAL statistics double-counting from parallel workers
Previous Message Hannu Krosing 2026-10-31 00:40:59 Re: ZSTD TOAST compression, and an extensible compression method encoding