diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out C:/cirrus/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out --- C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out 2024-08-17 03:18:28.783693400 +0000 +++ C:/cirrus/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out 2024-08-17 03:25:06.933010900 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pg_freespacemap; +ERROR: extension "pg_freespacemap" has no installation script nor update path for version "1.3" CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off); CREATE INDEX freespace_brin ON freespace_tab USING brin (c1); CREATE INDEX freespace_btree ON freespace_tab USING btree (c1); @@ -8,78 +9,39 @@ SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_hash | 0 | f - freespace_hash | 1 | f - freespace_hash | 2 | f - freespace_hash | 3 | f - freespace_hash | 4 | f - freespace_hash | 5 | f - freespace_hash | 6 | f - freespace_hash | 7 | f - freespace_hash | 8 | f - freespace_hash | 9 | f -(14 rows) - +ERROR: function pg_freespace(regclass) does not exist +LINE 3: FROM rel, LATERAL pg_freespace(rel.id) AS fsm + ^ +HINT: No function matches the given name and argument types. You might need to add explicit type casts. INSERT INTO freespace_tab VALUES (1); VACUUM freespace_tab; WITH rel AS (SELECT oid::regclass AS id FROM pg_class WHERE relname ~ 'freespace') SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_tab | 0 | t - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_btree | 1 | f - freespace_hash | 0 | f - freespace_hash | 1 | f - freespace_hash | 2 | f - freespace_hash | 3 | f - freespace_hash | 4 | f - freespace_hash | 5 | f - freespace_hash | 6 | f - freespace_hash | 7 | f - freespace_hash | 8 | f - freespace_hash | 9 | f -(16 rows) - +ERROR: function pg_freespace(regclass) does not exist +LINE 3: FROM rel, LATERAL pg_freespace(rel.id) AS fsm + ^ +HINT: No function matches the given name and argument types. You might need to add explicit type casts. DELETE FROM freespace_tab; VACUUM freespace_tab; WITH rel AS (SELECT oid::regclass AS id FROM pg_class WHERE relname ~ 'freespace') SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_btree | 1 | f - freespace_hash | 0 | f - freespace_hash | 1 | f - freespace_hash | 2 | f - freespace_hash | 3 | f - freespace_hash | 4 | f - freespace_hash | 5 | f - freespace_hash | 6 | f - freespace_hash | 7 | f - freespace_hash | 8 | f - freespace_hash | 9 | f -(15 rows) - +ERROR: function pg_freespace(regclass) does not exist +LINE 3: FROM rel, LATERAL pg_freespace(rel.id) AS fsm + ^ +HINT: No function matches the given name and argument types. You might need to add explicit type casts. -- failures with incorrect block number SELECT * FROM pg_freespace('freespace_tab', -1); -ERROR: invalid block number +ERROR: function pg_freespace(unknown, integer) does not exist +LINE 1: SELECT * FROM pg_freespace('freespace_tab', -1); + ^ +HINT: No function matches the given name and argument types. You might need to add explicit type casts. SELECT * FROM pg_freespace('freespace_tab', 4294967295); -ERROR: invalid block number +ERROR: function pg_freespace(unknown, bigint) does not exist +LINE 1: SELECT * FROM pg_freespace('freespace_tab', 4294967295); + ^ +HINT: No function matches the given name and argument types. You might need to add explicit type casts. DROP TABLE freespace_tab;