aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2003-07-09 08:51:19 +0000
committerBruce Momjian <bruce@momjian.us>2003-07-09 08:51:19 +0000
commit0ecc8ac4258e4d0670adb9f344299c9745445cdb (patch)
treed3e696e0ef959540bd9a7000c9e9665f3c2a337f /src
parentbf889e649acf5286e588ad824e3a6bb804cd59d1 (diff)
downloadpostgresql-0ecc8ac4258e4d0670adb9f344299c9745445cdb.tar.gz
postgresql-0ecc8ac4258e4d0670adb9f344299c9745445cdb.zip
Add special checks for non-super-user setting LOG_MIN_DURATION_STATEMENT
to zero.
Diffstat (limited to 'src')
-rw-r--r--src/backend/utils/misc/guc.c9
1 files changed, 5 insertions, 4 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c
index 11815b8c137..2769abd87e4 100644
--- a/src/backend/utils/misc/guc.c
+++ b/src/backend/utils/misc/guc.c
@@ -10,7 +10,7 @@
* Written by Peter Eisentraut <peter_e@gmx.net>.
*
* IDENTIFICATION
- * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.135 2003/07/09 06:47:34 momjian Exp $
+ * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.136 2003/07/09 08:51:19 momjian Exp $
*
*--------------------------------------------------------------------
*/
@@ -2529,12 +2529,13 @@ set_config_option(const char *name, const char *value,
if (record->context == PGC_USERLIMIT &&
source > PGC_S_USERSTART &&
conf->session_val != 0 &&
- newval > conf->session_val &&
+ (newval > conf->session_val ||
+ newval == 0) &&
!superuser())
{
elog(elevel, "'%s': permission denied\n"
- "Only super-users can increase this value.",
- name);
+ "Only super-users can increase this value "
+ "or set it to zero.", name);
return false;
}
/* Allow admin to override non-super user setting */