postgres
diff --git a/‎src/bin/psql/common.c
Copy file name to clipboardExpand all lines: src/bin/psql/common.c
+7Lines changed: 7 additions & 0 deletions b/‎src/bin/psql/common.c
Copy file name to clipboardExpand all lines: src/bin/psql/common.c
+7Lines changed: 7 additions & 0 deletions
diff --git a/‎src/bin/psql/variables.c
Copy file name to clipboardExpand all lines: src/bin/psql/variables.c
+18Lines changed: 18 additions & 0 deletions b/‎src/bin/psql/variables.c
Copy file name to clipboardExpand all lines: src/bin/psql/variables.c
+18Lines changed: 18 additions & 0 deletions
diff --git a/‎src/bin/psql/variables.h
Copy file name to clipboardExpand all lines: src/bin/psql/variables.h
+1Lines changed: 1 addition & 0 deletions b/‎src/bin/psql/variables.h
Copy file name to clipboardExpand all lines: src/bin/psql/variables.h
+1Lines changed: 1 addition & 0 deletions
diff --git a/‎src/test/regress/expected/psql.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/psql.out
+4Lines changed: 4 additions & 0 deletions b/‎src/test/regress/expected/psql.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/psql.out
+4Lines changed: 4 additions & 0 deletions
diff --git a/‎src/test/regress/sql/psql.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/psql.sql
+3Lines changed: 3 additions & 0 deletions b/‎src/test/regress/sql/psql.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/psql.sql
+3Lines changed: 3 additions & 0 deletions
@@ -795,6 +795,13 @@ StoreQueryTuple(const PGresult *result)
 			/* concatenate prefix and column name */
 			varname = psprintf("%s%s", pset.gset_prefix, colname);
 
+			if (VariableHasHook(pset.vars, varname))
+			{
+				psql_error("attempt to \\gset into specially treated variable \"%s\" ignored\n",
+						   varname);
+				continue;
+			}
+
 			if (!PQgetisnull(result, 0, i))
 				value = PQgetvalue(result, 0, i);
 			else
 
@@ -264,6 +264,24 @@ SetVariableAssignHook(VariableSpace space, const char *name, VariableAssignHook
 	return true;
 }
 
+/*
+ * Return true iff the named variable has an assign hook function.
+ */
+bool
+VariableHasHook(VariableSpace space, const char *name)
+{
+	struct _variable *current;
+
+	Assert(space);
+	Assert(name);
+
+	for (current = space->next; current; current = current->next)
+		if (strcmp(current->name, name) == 0)
+			return current->assign_hook != NULL;
+
+	return false;
+}
+
 bool
 SetVariableBool(VariableSpace space, const char *name)
 {
 
@@ -50,6 +50,7 @@ void		PrintVariables(VariableSpace space);
 
 bool		SetVariable(VariableSpace space, const char *name, const char *value);
 bool		SetVariableAssignHook(VariableSpace space, const char *name, VariableAssignHook hook);
+bool		VariableHasHook(VariableSpace space, const char *name);
 bool		SetVariableBool(VariableSpace space, const char *name);
 bool		DeleteVariable(VariableSpace space, const char *name);
 
 
@@ -10,6 +10,10 @@ select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_
 select 10 as "bad name"
 \gset
 could not set variable "bad name"
+select 'terse' as "OSITY", 'ok' as _foo \gset VERB
+attempt to \gset into specially treated variable "VERBOSITY" ignored
+\echo :VERB_foo :VERBOSITY
+ok default
 -- multiple backslash commands in one line
 select 1 as x, 2 as y \gset pref01_ \\ \echo :pref01_x
 1
 
@@ -13,6 +13,9 @@ select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_
 select 10 as "bad name"
 \gset
 
+select 'terse' as "OSITY", 'ok' as _foo \gset VERB
+\echo :VERB_foo :VERBOSITY
+
 -- multiple backslash commands in one line
 select 1 as x, 2 as y \gset pref01_ \\ \echo :pref01_x
 select 3 as x, 4 as y \gset pref01_ \echo :pref01_x \echo :pref01_y