Horton

Add pg_column_toast_chunk_id().

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: d1162cfda885c5a8cb9cebfc8eed9f1d76855e83
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2024-03-14T15:58:00Z
Releases: 17.0 
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

Files

PathChange+/−
doc/src/sgml/func.sgml modified +17 −0
src/backend/utils/adt/varlena.c modified +41 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +3 −0
src/test/regress/expected/misc_functions.out modified +16 −0
src/test/regress/sql/misc_functions.sql modified +12 −0

Documentation touched

Discussion