From acac94a3604df0656df91389a0c3b93254ba2db0 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 10 Jun 2009 22:12:28 +0000 Subject: [PATCH] Properly mark pg_freespace() function as strict. Also update uninstall script to match reality. --- contrib/pg_freespacemap/pg_freespacemap.sql.in | 2 +- contrib/pg_freespacemap/uninstall_pg_freespacemap.sql | 7 ++----- 2 files changed, 3 insertions(+), 6 deletions(-) diff --git a/contrib/pg_freespacemap/pg_freespacemap.sql.in b/contrib/pg_freespacemap/pg_freespacemap.sql.in index 5c67d8c90f..23e4245735 100644 --- a/contrib/pg_freespacemap/pg_freespacemap.sql.in +++ b/contrib/pg_freespacemap/pg_freespacemap.sql.in @@ -8,7 +8,7 @@ SET search_path = public; CREATE OR REPLACE FUNCTION pg_freespace(regclass, bigint) RETURNS int2 AS 'MODULE_PATHNAME', 'pg_freespace' -LANGUAGE C; +LANGUAGE C STRICT; -- pg_freespace shows the recorded space avail at each block in a relation CREATE OR REPLACE FUNCTION diff --git a/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql b/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql index 35dc02695c..f5ef77461c 100644 --- a/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql +++ b/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql @@ -3,8 +3,5 @@ -- Adjust this setting to control where the objects get dropped. SET search_path = public; -DROP VIEW pg_freespacemap_pages; -DROP VIEW pg_freespacemap_relations; - -DROP FUNCTION pg_freespacemap_pages(); -DROP FUNCTION pg_freespacemap_relations(); +DROP FUNCTION pg_freespace(regclass, bigint); +DROP FUNCTION pg_freespace(regclass); -- 2.39.5