|
10 | 10 | * Written by Peter Eisentraut <peter_e@gmx.net>. |
11 | 11 | * |
12 | 12 | * IDENTIFICATION |
13 | | - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.135 2003/07/0906:47:34 momjian Exp $ |
| 13 | + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.136 2003/07/0908:51:19 momjian Exp $ |
14 | 14 | * |
15 | 15 | *-------------------------------------------------------------------- |
16 | 16 | */ |
@@ -2529,12 +2529,13 @@ set_config_option(const char *name, const char *value, |
2529 | 2529 | if (record->context==PGC_USERLIMIT&& |
2530 | 2530 | source>PGC_S_USERSTART&& |
2531 | 2531 | conf->session_val!=0&& |
2532 | | -newval>conf->session_val&& |
| 2532 | +(newval>conf->session_val|| |
| 2533 | +newval==0)&& |
2533 | 2534 | !superuser()) |
2534 | 2535 | { |
2535 | 2536 | elog(elevel,"'%s': permission denied\n" |
2536 | | -"Only super-users can increase this value.", |
2537 | | -name); |
| 2537 | +"Only super-users can increase this value " |
| 2538 | +"or set it to zero.",name); |
2538 | 2539 | return false; |
2539 | 2540 | } |
2540 | 2541 | /* Allow admin to override non-super user setting */ |
|