v4-0010-Switch-pg_column_toast_chunk_id-return-value-from.patch
text/x-diff
Filename: v4-0010-Switch-pg_column_toast_chunk_id-return-value-from.patch
Type: text/x-diff
Part: 9
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v4-0010
Subject: Switch pg_column_toast_chunk_id() return value from oid to bigint
| File | + | − |
|---|---|---|
| doc/src/sgml/func/func-admin.sgml | 1 | 1 |
| src/backend/utils/adt/varlena.c | 1 | 1 |
| src/include/catalog/pg_proc.dat | 1 | 1 |
From f841b4bbafe5203fd9edc90b6fd8ad049ea253a0 Mon Sep 17 00:00:00 2001
From: Michael Paquier <michael@paquier.xyz>
Date: Fri, 8 Aug 2025 15:52:05 +0900
Subject: [PATCH v4 10/15] Switch pg_column_toast_chunk_id() return value from
oid to bigint
This is required for a follow-up patch that will add support for 8-byte
TOAST values, with this function being changed so as it is able to
support the largest TOAST value type available.
XXX: Bump catalog version.
---
src/include/catalog/pg_proc.dat | 2 +-
src/backend/utils/adt/varlena.c | 2 +-
doc/src/sgml/func/func-admin.sgml | 2 +-
3 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat
index 1f6df80ad312..27887436ede0 100644
--- a/src/include/catalog/pg_proc.dat
+++ b/src/include/catalog/pg_proc.dat
@@ -7735,7 +7735,7 @@
proargtypes => 'any', prosrc => 'pg_column_compression' },
{ oid => '6316', descr => 'chunk ID of on-disk TOASTed value',
proname => 'pg_column_toast_chunk_id', provolatile => 's',
- prorettype => 'oid', proargtypes => 'any',
+ prorettype => 'int8', proargtypes => 'any',
prosrc => 'pg_column_toast_chunk_id' },
{ oid => '2322',
descr => 'total disk space usage for the specified tablespace',
diff --git a/src/backend/utils/adt/varlena.c b/src/backend/utils/adt/varlena.c
index d76386407a08..26c720449f7b 100644
--- a/src/backend/utils/adt/varlena.c
+++ b/src/backend/utils/adt/varlena.c
@@ -4249,7 +4249,7 @@ pg_column_toast_chunk_id(PG_FUNCTION_ARGS)
toast_valueid = toast_external_info_get_value(attr);
- PG_RETURN_OID(toast_valueid);
+ PG_RETURN_UINT64(toast_valueid);
}
/*
diff --git a/doc/src/sgml/func/func-admin.sgml b/doc/src/sgml/func/func-admin.sgml
index 446fdfe56f4f..1e83584ac579 100644
--- a/doc/src/sgml/func/func-admin.sgml
+++ b/doc/src/sgml/func/func-admin.sgml
@@ -1571,7 +1571,7 @@ postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset
<primary>pg_column_toast_chunk_id</primary>
</indexterm>
<function>pg_column_toast_chunk_id</function> ( <type>"any"</type> )
- <returnvalue>oid</returnvalue>
+ <returnvalue>bigint</returnvalue>
</para>
<para>
Shows the <structfield>chunk_id</structfield> of an on-disk
--
2.50.0