Update /contrib for "autocommit TO 'on'".

Create objects in public schema.

Make spacing/capitalization consistent.

Remove transaction block use for object creation.

Remove unneeded function GRANTs.

1 files changed, 18 insertions, 13 deletions

diff --git a/contrib/pgstattuple/pgstattuple.sql.in b/contrib/pgstattuple/pgstattuple.sql.in
index 7ac7b6c11c..5489c93812 100644
--- a/contrib/pgstattuple/pgstattuple.sql.in
+++ b/contrib/pgstattuple/pgstattuple.sql.in
@@ -1,17 +1,22 @@
+-- Adjust this setting to control where the objects get created.
+SET search_path = public;
+
+SET autocommit TO 'on';
+
 DROP TYPE pgstattuple_type CASCADE;
 CREATE TYPE pgstattuple_type AS (
-    table_len BIGINT,		-- physical table length in bytes
-    tuple_count BIGINT,		-- number of live tuples
-    tuple_len BIGINT,		-- total tuples length in bytes
-    tuple_percent FLOAT,	-- live tuples in %
-    dead_tuple_count BIGINT,	-- number of dead tuples
-    dead_tuple_len BIGINT,	-- total dead tuples length in bytes
-    dead_tuple_percent FLOAT,	-- dead tuples in %
-    free_space BIGINT,		-- free space in bytes
-    free_percent FLOAT		-- free space in %
+	table_len BIGINT,		-- physical table length in bytes
+	tuple_count BIGINT,		-- number of live tuples
+	tuple_len BIGINT,		-- total tuples length in bytes
+	tuple_percent FLOAT,		-- live tuples in %
+	dead_tuple_count BIGINT,	-- number of dead tuples
+	dead_tuple_len BIGINT,		-- total dead tuples length in bytes
+	dead_tuple_percent FLOAT,	-- dead tuples in %
+	free_space BIGINT,		-- free space in bytes
+	free_percent FLOAT		-- free space in %
 );
 
-CREATE OR REPLACE FUNCTION pgstattuple(text) RETURNS pgstattuple_type
-  AS 'MODULE_PATHNAME', 'pgstattuple'
-  LANGUAGE 'c' WITH (isstrict);
-GRANT EXECUTE ON FUNCTION pgstattuple(text) TO PUBLIC;
+CREATE OR REPLACE FUNCTION pgstattuple(text)
+RETURNS pgstattuple_type
+AS 'MODULE_PATHNAME', 'pgstattuple'
+LANGUAGE 'C' WITH (isstrict);