postgres.git / summary / log / commit / refs

commit    41ed749e48b0b5f59c116a12241171a48eebe05a
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Mar 27 17:20:23 2025 +0000

    Prevent assertion failure in contrib/pg_freespacemap.
    
    Applying pg_freespacemap() to a relation lacking storage (such as a
    view) caused an assertion failure, although there was no ill effect
    in non-assert builds.  Add an error check for that case.
    
    Bug: #18866
    Reported-by: Robins Tharakan <tharakan@gmail.com>
    Author: Tender Wang <tndrwang@gmail.com>
    Reviewed-by: Euler Taveira <euler@eulerto.com>
    Discussion: https://postgr.es/m/18866-d68926d0f1c72d44@postgresql.org
    Backpatch-through: 13


 contrib/pg_freespacemap/pg_freespacemap.c | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/contrib/pg_freespacemap/pg_freespacemap.c b/contrib/pg_freespacemap/pg_freespacemap.c
index b82cab2d97e..2de3c764e79 100644
--- a/contrib/pg_freespacemap/pg_freespacemap.c
+++ b/contrib/pg_freespacemap/pg_freespacemap.c
@@ -11,6 +11,7 @@
 #include "access/relation.h"
 #include "funcapi.h"
 #include "storage/freespace.h"
+#include "utils/rel.h"
 
 PG_MODULE_MAGIC;
 
@@ -30,6 +31,13 @@ pg_freespace(PG_FUNCTION_ARGS)
 
 	rel = relation_open(relid, AccessShareLock);
 
+	if (!RELKIND_HAS_STORAGE(rel->rd_rel->relkind))
+		ereport(ERROR,
+				(errcode(ERRCODE_WRONG_OBJECT_TYPE),
+				 errmsg("relation \"%s\" does not have storage",
+						RelationGetRelationName(rel)),
+				 errdetail_relkind_not_supported(rel->rd_rel->relkind)));
+
 	if (blkno < 0 || blkno > MaxBlockNumber)
 		ereport(ERROR,
 				(errcode(ERRCODE_INVALID_PARAMETER_VALUE),


[parent: 4fd0156a6de9]