pgsql: Add pg_column_toast_chunk_id().

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add pg_column_toast_chunk_id().
Date: 2024-03-14 16:05:44
Message-ID: E1rknaS-003mQy-45@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add pg_column_toast_chunk_id().

This function returns the chunk_id of an on-disk TOASTed value. If
the value is un-TOASTed or not on-disk, it returns NULL. This is
useful for identifying which values are actually TOASTed and for
investigating "unexpected chunk number" errors.

Bumps catversion.

Author: Yugo Nagata
Reviewed-by: Jian He
Discussion: https://postgr.es/m/20230329105507.d764497456eeac1ca491b5bd%40sraoss.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d1162cfda885c5a8cb9cebfc8eed9f1d76855e83

Modified Files
--------------
doc/src/sgml/func.sgml | 17 ++++++++++++
src/backend/utils/adt/varlena.c | 41 ++++++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 3 ++
src/test/regress/expected/misc_functions.out | 16 +++++++++++
src/test/regress/sql/misc_functions.sql | 12 ++++++++
6 files changed, 90 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2024-03-14 18:57:37 pgsql: Make INSERT-from-multiple-VALUES-rows handle domain target colum
Previous Message Heikki Linnakangas 2024-03-14 13:32:00 pgsql: Remove redundant snapshot copying from parallel leader to worker