Backpatch: Fix typo in update scripts for some contrib modules.

MasaoFujii · anarazel · commit 7b6407d93d78 · 2014-08-25T18:30:46.000+02:00
Backpatch as discussed in 20140702192641.GD22738@awork2.anarazel.de ff. as the error messages are user facing and possibly confusing. Original commit: 6f9e39b
diff --git a/contrib/dblink/dblink--1.0--1.1.sql b/contrib/dblink/dblink--1.0--1.1.sql
@@ -1,6 +1,6 @@
 /* contrib/dblink/dblink--1.0--1.1.sql */
 
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
 \echo Use "ALTER EXTENSION dblink UPDATE TO '1.1'" to load this file. \quit
 
 CREATE FUNCTION dblink_fdw_validator(
diff --git a/contrib/hstore/hstore--1.0--1.1.sql b/contrib/hstore/hstore--1.0--1.1.sql
@@ -1,6 +1,6 @@
 /* contrib/hstore/hstore--1.0--1.1.sql */
 
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
 \echo Use "ALTER EXTENSION hstore UPDATE TO '1.1'" to load this file. \quit
 
 ALTER EXTENSION hstore DROP OPERATOR => (text, text);
diff --git a/contrib/pageinspect/pageinspect--1.0--1.1.sql b/contrib/pageinspect/pageinspect--1.0--1.1.sql
@@ -1,6 +1,6 @@
 /* contrib/pageinspect/pageinspect--1.0--1.1.sql */
 
--- complain if script is sourced in psql, rather than via ALTER EXTENSION UPDATE
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
 \echo Use "ALTER EXTENSION pageinspect UPDATE TO 1.1" to load this file. \quit
 
 DROP FUNCTION page_header(bytea);
diff --git a/contrib/pg_stat_statements/pg_stat_statements--1.0--1.1.sql b/contrib/pg_stat_statements/pg_stat_statements--1.0--1.1.sql
@@ -1,7 +1,7 @@
 /* contrib/pg_stat_statements/pg_stat_statements--1.0--1.1.sql */
 
 -- complain if script is sourced in psql, rather than via ALTER EXTENSION
-\echo Use "ALTER EXTENSION pg_stat_statements UPDATE" to load this file. \quit
+\echo Use "ALTER EXTENSION pg_stat_statements UPDATE TO '1.1'" to load this file. \quit
 
 /* First we have to remove them from the extension */
 ALTER EXTENSION pg_stat_statements DROP VIEW pg_stat_statements;
diff --git a/contrib/pg_trgm/pg_trgm--1.0--1.1.sql b/contrib/pg_trgm/pg_trgm--1.0--1.1.sql
@@ -1,6 +1,6 @@
 /* contrib/pg_trgm/pg_trgm--1.0--1.1.sql */
 
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
 \echo Use "ALTER EXTENSION pg_trgm UPDATE TO '1.1'" to load this file. \quit
 
 ALTER OPERATOR FAMILY gist_trgm_ops USING gist ADD
diff --git a/contrib/pgrowlocks/pgrowlocks--1.0--1.1.sql b/contrib/pgrowlocks/pgrowlocks--1.0--1.1.sql
@@ -1,7 +1,7 @@
 /* contrib/pgrowlocks/pgrowlocks--1.0--1.1.sql */
 
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
-\echo Use "CREATE EXTENSION pgrowlocks" to load this file. \quit
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
+\echo Use "ALTER EXTENSION pgrowlocks UPDATE TO '1.1'" to load this file. \quit
 
 ALTER EXTENSION pgrowlocks DROP FUNCTION pgrowlocks(text);
 DROP FUNCTION pgrowlocks(text);
