Seems there are three GUC variables that are defined as "Shows ..."
while you can actually set them with SET.
This applied patch changes the wording from "Show" to "Set".
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: src/backend/utils/misc/guc.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/backend/utils/misc/guc.c,v
retrieving revision 1.172
diff -c -c -r1.172 guc.c
*** src/backend/utils/misc/guc.c 29 Nov 2003 19:52:03 -0000 1.172
--- src/backend/utils/misc/guc.c 1 Dec 2003 03:50:41 -0000
***************
*** 808,814 ****
},
{
{"transaction_read_only", PGC_USERSET, CLIENT_CONN_STATEMENT,
! gettext_noop("Shows the current transaction's read-only
status."),
NULL,
GUC_NO_RESET_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
--- 808,814 ----
},
{
{"transaction_read_only", PGC_USERSET, CLIENT_CONN_STATEMENT,
! gettext_noop("Sets the current transaction's read-only
status."),
NULL,
GUC_NO_RESET_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
***************
*** 1532,1538 ****
{
/* Not for general use --- used by SET SESSION AUTHORIZATION */
{"session_authorization", PGC_USERSET, UNGROUPED,
! gettext_noop("Shows the session user name."),
NULL,
GUC_REPORT | GUC_NO_SHOW_ALL | GUC_NO_RESET_ALL |
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
--- 1532,1538 ----
{
/* Not for general use --- used by SET SESSION AUTHORIZATION */
{"session_authorization", PGC_USERSET, UNGROUPED,
! gettext_noop("Sets the session user name."),
NULL,
GUC_REPORT | GUC_NO_SHOW_ALL | GUC_NO_RESET_ALL |
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
***************
*** 1572,1578 ****
{
{"transaction_isolation", PGC_USERSET, CLIENT_CONN_STATEMENT,
! gettext_noop("Shows the current transaction's isolation
level."),
NULL,
GUC_NO_RESET_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
--- 1572,1578 ----
{
{"transaction_isolation", PGC_USERSET, CLIENT_CONN_STATEMENT,
! gettext_noop("Sets the current transaction's isolation
level."),
NULL,
GUC_NO_RESET_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
