mirror of
https://github.com/postgres/postgres.git
synced 2025-07-28 23:42:10 +03:00
3c4d7557e0
An assertion test added in commit049ef33could fail when pg_prewarm() was called on objects without storage, such as partitioned tables. This resulted in the following failure in assert-enabled builds: Failed Assert("RelFileNumberIsValid(rlocator.relNumber)") Note that, in non-assert builds, pg_prewarm() just failed with an error in that case, so there was no ill effect in practice. This commit fixes the issue by having pg_prewarm() raise an error early if the specified object has no storage. This approach is similar to the fix in commit4623d7144for pg_freespacemap. Back-patched to v17, where the issue was introduced. Author: Masahiro Ikeda <ikedamsh@oss.nttdata.com> Reviewed-by: Dilip Kumar <dilipbalaut@gmail.com> Reviewed-by: Richard Guo <guofenglinux@gmail.com> Reviewed-by: Fujii Masao <masao.fujii@gmail.com> Discussion: https://postgr.es/m/e082e6027610fd0a4091ae6d033aa117@oss.nttdata.com Backpatch-through: 17
11 lines
271 B
SQL
11 lines
271 B
SQL
-- Test pg_prewarm extension
|
|
CREATE EXTENSION pg_prewarm;
|
|
|
|
-- pg_prewarm() should fail if the target relation has no storage.
|
|
CREATE TABLE test (c1 int) PARTITION BY RANGE (c1);
|
|
SELECT pg_prewarm('test', 'buffer');
|
|
|
|
-- Cleanup
|
|
DROP TABLE test;
|
|
DROP EXTENSION pg_prewarm;
|