v2-0008-Switch-pg_column_toast_chunk_id-return-value-from.patch
text/x-diff
Filename: v2-0008-Switch-pg_column_toast_chunk_id-return-value-from.patch
Type: text/x-diff
Part: 7
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 v2-0008
Subject: Switch pg_column_toast_chunk_id() return value from oid to bigint
| File | + | − |
|---|---|---|
| doc/src/sgml/func.sgml | 1 | 1 |
| src/backend/utils/adt/varlena.c | 1 | 1 |
| src/include/catalog/pg_proc.dat | 1 | 1 |
From 32e2696d65fa244ed7ed007164144285cd9fe911 Mon Sep 17 00:00:00 2001
From: Michael Paquier <michael@paquier.xyz>
Date: Thu, 19 Jun 2025 10:11:40 +0900
Subject: [PATCH v2 08/13] 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.
---
src/include/catalog/pg_proc.dat | 2 +-
src/backend/utils/adt/varlena.c | 2 +-
doc/src/sgml/func.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 ff0871037c53..822874a6a5e0 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.sgml b/doc/src/sgml/func.sgml
index 74bd691b0a8f..cab7ef816b6e 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -30121,7 +30121,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