agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add relation option toast_value_type
Date: Fri, 11 Sep 2026 03:34:19 +0000
Message-ID: <E1x4s1q-00000004Nip-1kAW@gemulon.postgresql.org> (raw)
Add relation option toast_value_type
This relation option gives the possibility to define the attribute type
that can be used for chunk_id in a TOAST table when it is initially
created. An update of this parameter has no effect if a TOAST table
already exists under the relation, even on rewrites. It cannot be set
for TOAST relations.
This new option can be set only to "oid" as of this commit. This
feature is extracted as a patch of its own to ease the introduction of a
second mode in a follow-up change, related to the introduction of 8-byte
OIDs in external TOAST pointers.
Bump catalog version, as StdRdOptions has changed.
Author: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Greg Burd <greg@burd.me>
Reviewed-by: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Reviewed-by: Yugo Nagata <nagata@sraoss.co.jp>
Discussion: https://postgr.es/m/af19kUjwjhaoUTLn@paquier.xyz
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/f33844889bb6950f9c207b9ea4830947f1e1f50e
Modified Files
--------------
doc/src/sgml/ref/create_table.sgml | 26 ++++++++++++++++++++++++++
src/backend/access/common/reloptions.c | 21 +++++++++++++++++++++
src/backend/catalog/toasting.c | 16 ++++++++++++++++
src/bin/psql/tab-complete.in.c | 1 +
src/include/catalog/catversion.h | 2 +-
src/include/utils/rel.h | 17 +++++++++++++++++
src/test/regress/expected/reloptions.out | 22 ++++++++++++++++++++++
src/test/regress/sql/reloptions.sql | 12 ++++++++++++
src/tools/pgindent/typedefs.list | 1 +
9 files changed, 117 insertions(+), 1 deletion(-)
Message-ID: <E1x4s1q-00000004Nip-1kAW@gemulon.postgresql.org>
Permalink: ../E1x4s1q-00000004Nip-1kAW@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1x4s1q-00000004Nip-1kAW@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add relation option toast_value_type
In-Reply-To: <E1x4s1q-00000004Nip-1kAW@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox