diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-06-10 22:12:28 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-06-10 22:12:28 +0000 |
| commit | 15a3fe6d6343ae46b9e28a093b8dea422c31af83 (patch) | |
| tree | 78005ac33d9b18f6170e3395e6a13eddb537b106 /contrib/pg_freespacemap | |
| parent | 5e29862aa2b7aa45f525c978ea764673f60ccd5f (diff) | |
| download | postgresql-15a3fe6d6343ae46b9e28a093b8dea422c31af83.tar.gz | |
Properly mark pg_freespace() function as strict. Also update
uninstall script to match reality.
Diffstat (limited to 'contrib/pg_freespacemap')
| -rw-r--r-- | contrib/pg_freespacemap/pg_freespacemap.sql.in | 4 | ||||
| -rw-r--r-- | contrib/pg_freespacemap/uninstall_pg_freespacemap.sql | 9 |
2 files changed, 5 insertions, 8 deletions
diff --git a/contrib/pg_freespacemap/pg_freespacemap.sql.in b/contrib/pg_freespacemap/pg_freespacemap.sql.in index d9bab1a579..7054380386 100644 --- a/contrib/pg_freespacemap/pg_freespacemap.sql.in +++ b/contrib/pg_freespacemap/pg_freespacemap.sql.in @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/contrib/pg_freespacemap/pg_freespacemap.sql.in,v 1.11 2008/10/02 12:20:50 heikki Exp $ */ +/* $PostgreSQL: pgsql/contrib/pg_freespacemap/pg_freespacemap.sql.in,v 1.12 2009/06/10 22:12:28 tgl Exp $ */ -- Adjust this setting to control where the objects get created. SET search_path = public; @@ -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 a8bf64387d..e9bf0ad7d1 100644 --- a/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql +++ b/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql @@ -1,10 +1,7 @@ -/* $PostgreSQL: pgsql/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql,v 1.4 2008/09/30 11:17:07 heikki Exp $ */ +/* $PostgreSQL: pgsql/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql,v 1.5 2009/06/10 22:12:28 tgl Exp $ */ -- 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); |