blob: 94e4fa1a9d2372e71badd72b8d6f6e034981c432 (
plain)
1
2
3
4
5
6
7
8
9
10
|
-- 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');
ERROR: relation "test" does not have storage
DETAIL: This operation is not supported for partitioned tables.
-- Cleanup
DROP TABLE test;
DROP EXTENSION pg_prewarm;
|