diff options
| -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 d9bab1a579a..70543803867 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 a8bf64387d9..e9bf0ad7d1a 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); |