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, 8 insertions, 5 deletions

diff --git a/contrib/noupdate/noup.sql.in b/contrib/noupdate/noup.sql.in
index 283876258b8..47213779b46 100644
--- a/contrib/noupdate/noup.sql.in
+++ b/contrib/noupdate/noup.sql.in
@@ -1,6 +1,9 @@
-DROP FUNCTION noup ();
+-- Adjust this setting to control where the objects get created.
+SET search_path = public;
 
-CREATE FUNCTION noup ()
-	RETURNS trigger
-	AS 'MODULE_PATHNAME'
-	LANGUAGE 'C';
+SET autocommit TO 'on';
+
+CREATE OR REPLACE FUNCTION noup ()
+RETURNS trigger
+AS 'MODULE_PATHNAME'
+LANGUAGE 'C';